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

Posted on 2008-11-13
Last Modified: 2013-12-19

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!
Question by:TerryBuck
    LVL 38

    Expert Comment

    by:Jim P.
    Have you tried running the ODBCAD32 under the SysWOW directory?
    LVL 1

    Accepted Solution


    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    The use of stolen credentials is a hot commodity this year allowing threat actors to move laterally within the network in order to avoid breach detection.
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now