Hi All,
We have DataStage6.0 Server edition on IBM AIX 5.1 server(Eg:123.312.12.111)
SQL Server 2000 DB(DB name is "MYDB") is on Windows NT server(Eg:110.211.10.121).
I would like to configure SQL Server 2000 ODBC driver and Set-up DB connection on DS 6.0(Unix) server.
Could anyone explain what are all the series of steps I have to do.
Your help is greatly appreciated.
Thanks
Regards
ShV
SQL Server 2000 ODBC Configuration/Connection set-up
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 123
- Joined: Wed May 18, 2005 7:41 am
- Location: USA
Please see manuals for details
Edit your .odbc.ini in your Ascential DSengine directory.
Copy the sample sql server details to the end of file and substitute your database, sql server hostname or ipaddress along with the port.
Now go to your project directory and edit your uvodbc.config file
<SAMENAME that your gave in .odbc.ini>
DBMSTYPE = ODBC
save it
and test your connection from DS engine shell
Make this changes as dsadm user for being secure.
Edit your .odbc.ini in your Ascential DSengine directory.
Copy the sample sql server details to the end of file and substitute your database, sql server hostname or ipaddress along with the port.
Now go to your project directory and edit your uvodbc.config file
<SAMENAME that your gave in .odbc.ini>
DBMSTYPE = ODBC
save it
and test your connection from DS engine shell
Make this changes as dsadm user for being secure.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Since the class A IP addresses indicate different domains, you will also need to ensure that there is connectivity, using ping from the DataStage server machine to the machine where SQL Server is installed.
If you can't ping the other machine, you will need to talk with your network administrator about configuring a route from the one to the other.
If you can't ping the other machine, you will need to talk with your network administrator about configuring a route from the one to the other.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 123
- Joined: Wed May 18, 2005 7:41 am
- Location: USA