SQL ODBC Connection
Posted: Wed Oct 11, 2006 2:34 am
Hi,
I am running DataStage 7.5 on a Solaris 2.8 platform.
ONe of the source systems changed from SQL Server 7 to SQL Server 2000. My ODBC connection to SQL Server 7 and everything else works fine.
My .odbc.ini for SQL Server 7 looks like this:
[empower]
Driver=/export/home/dsadm/Ascential/DataStage/DSEngine/../branded_odbc/lib/VMmsss18.so
Description=DataDirect SQL Server Wire Protocol
Address=empower,1433
AnsiNPW=No
Database=PWA
LogonID=sa
Password=
QuotedId=No
The problem that i have now is that i need to connect to the SQL Server 2000 database which has 2 instances running on it:
1. GPSQLI1\SQLINSTANCE1
2. GPSQLI2\SQLINSTANCE2
both of which reside on the server GPSQL01 IP 10.0.4.54
The instance that im interested in is no 2 above. How do i reference it in my .odbc.ini.
Thanks in advance.
Faeez
I am running DataStage 7.5 on a Solaris 2.8 platform.
ONe of the source systems changed from SQL Server 7 to SQL Server 2000. My ODBC connection to SQL Server 7 and everything else works fine.
My .odbc.ini for SQL Server 7 looks like this:
[empower]
Driver=/export/home/dsadm/Ascential/DataStage/DSEngine/../branded_odbc/lib/VMmsss18.so
Description=DataDirect SQL Server Wire Protocol
Address=empower,1433
AnsiNPW=No
Database=PWA
LogonID=sa
Password=
QuotedId=No
The problem that i have now is that i need to connect to the SQL Server 2000 database which has 2 instances running on it:
1. GPSQLI1\SQLINSTANCE1
2. GPSQLI2\SQLINSTANCE2
both of which reside on the server GPSQL01 IP 10.0.4.54
The instance that im interested in is no 2 above. How do i reference it in my .odbc.ini.
Thanks in advance.
Faeez