SQL ODBC Connection

[fkana]

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

[Ultramundane]

You reference it just as you mentioned. ServerAlias\SQLinstance.

[fkana]

Where in the following do i insert it:
[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

Tx.

Faeez

[Ultramundane]

[empower]
Driver=/export/home/dsadm/Ascential/DataStage/DSEngine/../branded_odbc/lib/VMmsss18.so
Description=DataDirect SQL Server Wire Protocol
Address=ServerAlias\SQLinstance
AnsiNPW=No
Database=PWA
LogonID=sa
Password=
QuotedId=No

[fkana]

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

[Ultramundane]

There is currently an on-going issue in the server area for possibly same issue.