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:
[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:
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 Network Configuration File: M:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
(ADDRESS = (PROTOCOL = TCP)(HOST = czdbfs-oracle-svc.coverzones.com)(PORT = 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!