Problem connecting Access to Oracle

J

JonR

I'm having a problem connecting Access to an oracle database. I went through
the steps and set up the ODBC drivers, and I get the following error message:

[Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS: could not resolve
the connect identifier specified (12154)[Microsoft][ODBC Driver
Manager]Driver's SQLSetConnectAttr failed IM006 0 [Microsoft][ODBC Driver
Manager] Driver's SQLSetConnect Attr failed (#0)

Using Access 2000. Any ideas?

Thanks
--
HTH

JonR

Please rate your posts
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC - Connecting MS Access to Oracle 10g 0
Access 2007 connecting to Oracle 9i 1
Oracle ODBC Link fails 2
ODBC and Sage 0
Excel Error Attachting to Oracle - Advanced Problem 0
Access 2007 ODBC for Oracle linked table issue 1
ORA-12203 error in ODBC connection 0
access 2003 - ODBC oracle 1

Top