Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2009

    Unanswered: MS Access - Connecting To Oracle Using Odbc


    I have been using ODBC (Oracle ODBC Drivers) to create SQL Pass Through Queries in MS ACCESS for many years. Recently as a result of security upgrade, our Oracle DB port was changed from Port 1521 to 1531.

    I was asked to update the TNSNAMES.ORA to update the port information to be able to access the Oracel DB. Using SQLPlus, with the updated port I can login. But MS ACCESS does not let me use the SQL Pass Throught Queries any more and gives me a message "ODBC--Call Failed" in a popup window Connection String Builder.

    I will appreciate any ones guidance. The Oracle ODBC Driver System DSN Entry lets me successfully test the connection. It is MS Access that does not let me through.

  2. #2
    Join Date
    Sep 2005

    This may sound stupid but...

    did you use the "linked table manager " tool in access to update the links?

  3. #3
    Join Date
    Aug 2009
    I have tried linking the tables as well as creating a new Pass Through Query. Both of them are not letting me through. It seems to be a problem that seems to be limited to database that is other than port 1521 as the databases that have port 1521 I can easily work with.

  4. #4
    Join Date
    Nov 2007
    Adelaide, South Australia
    Could it be a router/firewall issue?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts