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.
ODBC Connection
Moderators: chulett, rschirm, roy