SQL Server Connection
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 97
- Joined: Tue Feb 21, 2006 6:45 am
SQL Server Connection
I want to connect to SQLServer, and I am using Ascential 7.5.1. I dont see any plugin of SQLServer. Is it abnormal, not to have plugin for SQLServer???
Will DRS (Dynamic RDBMS stage), work to extract data from SQLServer??? (I heard this from someone,but not for sure).
or do i need to go for ODBC only, is there no other stage???
and does ODBC connectivity work for SQLServer. Because ODBC connectivity didnt work for netezza in version 7.5.1
Will DRS (Dynamic RDBMS stage), work to extract data from SQLServer??? (I heard this from someone,but not for sure).
or do i need to go for ODBC only, is there no other stage???
and does ODBC connectivity work for SQLServer. Because ODBC connectivity didnt work for netezza in version 7.5.1
-
- Participant
- Posts: 145
- Joined: Fri May 02, 2003 9:59 am
- Location: Seattle, Washington. USA
If you are on Unix then your only choice is ODBC. DRS may support SQL Server but it would still be using the ODBC drivers.kris007 wrote:There should be a plug-in available for SQL Server. May be it was not installed. Besides, you can also use DRS and ODBC to connect to SQLserver and extract data. I have connected to SQLServer using plug-in and ODBC earlier.
Shawn Ramsey
"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
Set up the ODBC connection, make sure you use a hostname and not an IP if your SQL-Server is on a DHCP assigned machine. Also, you need the port number as well, very important.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You could hunt for a version of SQL Server that runs on UNIX, but you won't find one. You could create your own plug-in stage, but it's really not worth the effort. The vendor supplies a UNIX-based ODBC driver that can connect to SQL Server on Windows.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.