DSXchange

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.

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.

I will do that.Thanks a lot.