DataStage Server Routine using DSN

maheshalways · Post by **maheshalways** » Mon Aug 17, 2009 12:45 pm

Hi,

I have a DataStage Server Routine, which connects to DB2, I need to modify the Server Routine to connect to SQL Server Database (Installed on Different Server). I have DSN Name,USER ID, PASSWORD. I have also set up ODBC to connect to SQL SERVER on my DataStage Server. I need to know the syntax to connect from DataStage Server routine using all the above info. Any help would be greatly appreciated.

Regards,
Mahesh

chulett · Post by **chulett** » Mon Aug 17, 2009 1:28 pm

I don't think it (the syntax) changes. Just the values you pass.

ray.wurlod · Post by **ray.wurlod** » Mon Aug 17, 2009 4:53 pm

Nothing changes. All ODBC drivers present the same solution (essentially the ODBC API) no matter which database they actually connect to.