MS Access 2003 linking to oracle database

Z

Zoe

Morning,

I'm running MS Access 2003 on Windows 2003 Server 64-bit edition. I am
trying to link tables to an Oracle 9 database on AIX.

When I try to get link the tables I get an ODBC--call failed error message
and an ORA-12154: TNS: failed to resolve service name error.

I'ma bit baffled as when I do a TNSPING to the database it suceeds. And when
I try ODBC (the 32 bit version) the connection also works. The problem only
turns up when I try MS Access. Can anyone help?

Thanks in advance for any help.

Zoe
 

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

MS Access - linking table problem 3
ODBC - Connecting MS Access to Oracle 10g 0
Problem connecting Access to Oracle 0
MS Oracle ODBC failure in Access 07 3
ISO best steps to export (import) all from Outlook 2003 to Outlook in MS 365 0
Outlook linking to non default browser Edge 0
REINSTALLING MS OFFICE PRO PLUS 2019 0
Access 2003 not linked to Oracle 11g 3

Top