Home » Infrastructure » Windows » Using ODBC to connect to DB2
Using ODBC to connect to DB2 [message #100636] Tue, 25 March 2003 11:24
GL
Messages: 2
Registered: March 2003
Junior Member
I'm tying to connect to an ODBC connection and am getting an error, while running on NT V4, and Oracle v8.0.3.

I cannot connect by issuing the following from the <Start><RUN> Command line
PLUS80W.EXE user/passwd@odbc:db2_dev

I get the following error message:
ORA-12154: TNS:could not resolve service name

Yet I can connect using Oracle's "Oracle ODBC Test", selecting the proper 'machine data source' and typing in the username and password.

Any ideas on how to proceed?

Do I need to add a service name to the tnsnames.ora file, if so, can someone provide a sample for an ODBC source?

Thanks
GL
Previous Topic: RAID dump recovery-Windows NT Server 4
Next Topic: How to build and call complex queries through ADO
Goto Forum:
  


Current Time: Thu Mar 28 08:16:10 CDT 2024