OraFAQ Forum: Windows » Using ODBC to connect to DB2

Home » Infrastructure » Windows » Using ODBC to connect to DB2

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 23:59:21 CST 2024