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
 
Top