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

Hi,

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 czdbfs-oracle-svc.coverzones.com (results below):

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

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

Used parameter files:
M:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\sqlnet.ora

Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=czdbfs-oracle-svc.coverzones.com))(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.174.163)(PORT=1521)))
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 10.02.00.01.

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.

CZ_PROD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = czdbfs-oracle-svc.coverzones.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (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!
TerryBuckAsked:
Who is Participating?
 
Jim P.Commented:
Have you tried running the ODBCAD32 under the SysWOW directory?
0
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.