DSXchange

Greetings - I am searching for a work around solution for connecting to a
SQL Server 2000 Database using ODBC. We currently have DataStage 5.1 and
the only SQL Server driver we have is VMmsss15.so. I'm thinking we could
possibly link a SQL Server 6.5 version to the SQL Server 2000 version and
then point to the SQL Server 6.5 version. I would be very grateful to any
help with in accomplishing this or a suggestions for a better solution.

Thank you,
Joel Kalton

Joel

I have done this. It works very well.

Thanks Kim.
Kim Duke
DsWebMon - Safely Monitor DataStage from the Web
www.Duke-Consulting.com


-----Original Message-----
From: Kalton, Joel [mailto:Joel.Kalton@cignabehavioral.com]
Sent: Monday, November 17, 2003 11:19 AM
To: datastage-users@oliver.com
Subject: SQL Server 2000

Greetings - I am searching for a work around solution for connecting to
a
SQL Server 2000 Database using ODBC. We currently have DataStage 5.1
and
the only SQL Server driver we have is VMmsss15.so. I'm thinking we
could
possibly link a SQL Server 6.5 version to the SQL Server 2000 version
and
then point to the SQL Server 6.5 version. I would be very grateful to
any
help with in accomplishing this or a suggestions for a better solution.

Thank you,
Joel Kalton

Kim - Our SQL Server DBA is asking for instructions on how you accomplished
this. Are they available?

Much appreciated,
Joel

-----Original Message-----
From: Kim Duke [mailto:Kim_G_Duke@Yahoo.com]
Sent: Monday, November 17, 2003 12:19 PM
To: datastage-users@oliver.com
Subject: RE: SQL Server 2000


Joel

I have done this. It works very well.

Thanks Kim.
Kim Duke
DsWebMon - Safely Monitor DataStage from the Web
www.Duke-Consulting.com


-----Original Message-----
From: Kalton, Joel [mailto:Joel.Kalton@cignabehavioral.com]
Sent: Monday, November 17, 2003 11:19 AM
To: datastage-users@oliver.com
Subject: SQL Server 2000

Greetings - I am searching for a work around solution for connecting to
a
SQL Server 2000 Database using ODBC. We currently have DataStage 5.1
and
the only SQL Server driver we have is VMmsss15.so. I'm thinking we
could
possibly link a SQL Server 6.5 version to the SQL Server 2000 version
and
then point to the SQL Server 6.5 version. I would be very grateful to
any
help with in accomplishing this or a suggestions for a better solution.

Thank you,
Joel Kalton

Joel

It has been over a year but it seems the difference is that SQL Server
2000 supports multiple databases on one server. We created a special
user like etluser. This user defaulted to a schema which was a dblink to
SQL Server 2000 on the other machine. Just passes everything through the
older version of SQL Server to the newer one. We used bulk load and did
not have to change any DataStage job. Worked great.

Thanks Kim.
Kim Duke
DsWebMon - Safely Monitor DataStage from the Web
www.Duke-Consulting.com


-----Original Message-----
From: Kalton, Joel [mailto:Joel.Kalton@cignabehavioral.com]
Sent: Monday, November 17, 2003 12:57 PM
To: 'datastage-users@oliver.com'
Subject: RE: SQL Server 2000

Kim - Our SQL Server DBA is asking for instructions on how you
accomplished
this. Are they available?

Much appreciated,
Joel

-----Original Message-----
From: Kim Duke [mailto:Kim_G_Duke@Yahoo.com]
Sent: Monday, November 17, 2003 12:19 PM
To: datastage-users@oliver.com
Subject: RE: SQL Server 2000


Joel

I have done this. It works very well.

Thanks Kim.
Kim Duke
DsWebMon - Safely Monitor DataStage from the Web
www.Duke-Consulting.com


-----Original Message-----
From: Kalton, Joel [mailto:Joel.Kalton@cignabehavioral.com]
Sent: Monday, November 17, 2003 11:19 AM
To: datastage-users@oliver.com
Subject: SQL Server 2000

Greetings - I am searching for a work around solution for connecting to
a
SQL Server 2000 Database using ODBC. We currently have DataStage 5.1
and
the only SQL Server driver we have is VMmsss15.so. I'm thinking we
could
possibly link a SQL Server 6.5 version to the SQL Server 2000 version
and
then point to the SQL Server 6.5 version. I would be very grateful to
any
help with in accomplishing this or a suggestions for a better solution.

Thank you,
Joel Kalton