ODBC Connection

ksmurthys · Post by **ksmurthys** » Tue Sep 21, 2004 12:32 pm

Hi,

My environment:
ETL Tool:Datastage 4.2 on Windows NT.
Database:SQL SERVER Standard Edition on Windows NT -5.0

I tried to connect to SQLSERVER using ODBC stage.I am getting following message:
DSBrowser1: DSD.BCIConnect connecting to DSN1, call to SQLConnect failed.
SQLSTATE=IM002, DBMS.CODE=0
[Ardent][SQL Client][ODBC][Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.I created ODBC driver DSN1 for SQLserver on my machine i.e client machine.
Pls let me know how do i connect to SQLServer using ODBC satge??

Thanks in Advance.

KeithM · Post by **KeithM** » Tue Sep 21, 2004 12:48 pm

You need to create your ODBC DSN on the server running Datastage, not your individual client machine. The client for SQL server is the Datastage server.

ksmurthys · Post by **ksmurthys** » Tue Sep 21, 2004 1:49 pm

I will do that.Thanks a lot.