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
SQL Server 2000
SQL Server 2000
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
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
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
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
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
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
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
SQL Server 2000
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
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
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.