Link data source by creating a link table to an Oracle DB from MS Access 2007


We receive the following error when trying to link to a data source by creating a linked table to an Oracle DB in Microsoft Access 2007:

ODBC-Call failed.

[Oracle][ODBC][Ora]ORA-12154: TNS could not resolve the connect identifier specified
(#12154) [Microsoft][ODBC Driver Manager] Drivers SQLSetConnectAttr failed IM0006 0 [Microsoft][ODBC Driver Manager] Drivers SQLSetConnectAttr failed (#0)

We can run a successful test to the database from Oracle Net Manager and also from ODBC Source Administrator.  I can do a tnsping to the host server (results below):

TNS Ping Utility for 32-bit Windows: Version - Production on 05-NOV-2008 15:44:54

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:

Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(
OK (60 msec)

The server is running Windows 2003 Server 64-bit OS in a Citrix environment.  We originally tried installing the 64-bit Oracle client and could also run a successful test to the Oracle database server from Oracle Net Manager & ODBC Administrator, but MS Access only looks for the 32-bit client ODBC drivers so had to install the 32-bit Oracle client on the 64-bit server.

Oracle Client version is 10g, driver version is

tnsnames.ora file:
# tnsnames.ora Network Configuration File: M:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

      (ADDRESS = (PROTOCOL = TCP)(HOST = = 1521))
      (SERVICE_NAME = czn)

Any other information you require, please let me know.  Any help would be very much apreciated as I have been banging my head agaist a brink wall all week!
Who is Participating?
Jim P.Commented:
Have you tried running the ODBCAD32 under the SysWOW directory?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.