Results 1 to 2 of 2
  1. #1
    drdexter33 is offline Novice
    Windows 2K Access 2003
    Join Date
    Mar 2010
    Posts
    1

    ODBC -- call failed. | Oracle ODBC

    I have an Access 2003 Database that resides on a virtual windows 2003 server that is giving me an error when I attempt to create a linked table or update any linked table that is using an odbc file dsn. The database being connected to is Oracle.



    Here's the full error.



    Now the weird thing is, the error is only occurring on a virtual machine while on my local development box, it works fine.

    Both environments are using identical tnsfilename.ora files.

    The failing server is running Windows Server 2003 with MS ODBC for Oracle v2.576.3959.000.
    The dev box is running WinXP Pro with MS ODBC for Oracle v2.575.1132.00

    Thanks in advance.

    Doug

  2. #2
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    I suspect that your DSN connection is incorrect.

    Try linking manually to one of your Oracle tables. If you can't, it's a bad DSN, if you can you programmatic linking is bad.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 11-10-2009, 02:49 PM
  2. ODBC and Long Query Time
    By pdouglas in forum Access
    Replies: 0
    Last Post: 07-09-2009, 10:21 AM
  3. ODBC related struggles
    By gray8110 in forum Access
    Replies: 0
    Last Post: 12-08-2008, 02:31 AM
  4. ODBC connectivity issues
    By Telly in forum Import/Export Data
    Replies: 0
    Last Post: 05-07-2007, 08:03 AM
  5. ODBC Connectivity
    By hiker8117 in forum Import/Export Data
    Replies: 0
    Last Post: 02-23-2007, 03:46 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums