MS Access - linking table problem

[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

 

[Guest]

Are you using a file DSN in both cases?

Have you tried from Excel?

(david)

 

[Zoe]

Hi,

Thanks for the reply. I hadn't thought of connecting from Excel.

I have tried from Excel and this also got an ORA-12154: TNS could not
resolve service name error. That was using a file dsn.

- Zoe

 

[Guest]

I wondered about the file DSN because I expect that you can
open the file DSN and see what is inside it, to see if that gives
you any clues.

Since it is a general ODBC problem rather than an Access
specific problem, perhaps some one who knows about
Oracle will have some ideas.

(david)