SQL Server 2000 ODBC Configuration/Connection set-up

satish_valavala · Post by **satish_valavala** » Tue May 31, 2005 2:29 pm

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

bryan · Post by **bryan** » Tue May 31, 2005 3:22 pm

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.

ray.wurlod · Post by **ray.wurlod** » Tue May 31, 2005 5:27 pm

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.

satish_valavala · Post by **satish_valavala** » Tue May 31, 2005 8:01 pm

Thanks Bryan and Ray.