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
SQL ODBC Connection
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact:
Re: SQL ODBC Connection
You reference it just as you mentioned. ServerAlias\SQLinstance.
-
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact:
Ive tried that but it does not work.
One of the source systems changed from SQL Server 7 to SQL Server
2000. My ODBC connection to SQL Server 7 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
When i ping GPSQLI1 i get 10.0.4.65 and when i ping GPSQLI2 i get 10.0.4.66.
The instance that im interested in is no 2 above. How do i reference
it in my .odbc.ini.
My hosts file looks like this:
10.0.4.66 empower
This is what ive tried:
[empower]
Driver=/export/home/dsadm/Ascential/DataStage/DSEngine/../branded_odbc/lib/VMmsss18.so
Description=DataDirect SQL Server Wire Protocol
Address=empower\SQLINSTANCE2,1433
AnsiNPW=No
Database=PWA
LogonID=sa
Password=
QuotedId=No
One of the source systems changed from SQL Server 7 to SQL Server
2000. My ODBC connection to SQL Server 7 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
When i ping GPSQLI1 i get 10.0.4.65 and when i ping GPSQLI2 i get 10.0.4.66.
The instance that im interested in is no 2 above. How do i reference
it in my .odbc.ini.
My hosts file looks like this:
10.0.4.66 empower
This is what ive tried:
[empower]
Driver=/export/home/dsadm/Ascential/DataStage/DSEngine/../branded_odbc/lib/VMmsss18.so
Description=DataDirect SQL Server Wire Protocol
Address=empower\SQLINSTANCE2,1433
AnsiNPW=No
Database=PWA
LogonID=sa
Password=
QuotedId=No
-
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact: