Results 1 to 4 of 4
  1. #1
    jarora is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2018
    Posts
    2

    ODBC connection to oracle database works but gives error thru access

    OS : Windows 10
    User can connect to Oracle database using 11g 32 bit ODBC driver under USER DSN



    User gets error when using microsoft access 2016 to run query using same ODBC connections
    Error: ODBC connection to <NAME> failed

    Has anybody faced same issue . Thanks

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Do you have an account (I think tnsnames) on Oracle? Have you talked to the Oracle DBA?
    I haven't used oracle for 8+ year.

  3. #3
    jarora is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2018
    Posts
    2
    Quote Originally Posted by orange View Post
    Do you have an account (I think tnsnames) on Oracle? Have you talked to the Oracle DBA?
    I haven't used oracle for 8+ year.
    Yes , account exists and connection succeeds thru ODBC Data source window but fails in access.

  4. #4
    GrzesN is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2018
    Posts
    2
    I have a similar problem with MySQL ODBC connections. Maybe this is not a database problem?

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

Similar Threads

  1. Replies: 1
    Last Post: 08-18-2017, 10:00 AM
  2. ODBC connection for Access 2016 - results in error
    By Ashish_Panchal in forum Access
    Replies: 3
    Last Post: 11-25-2016, 01:35 AM
  3. Replies: 1
    Last Post: 03-02-2015, 09:44 AM
  4. Replies: 2
    Last Post: 09-19-2012, 12:01 AM
  5. Replies: 2
    Last Post: 11-10-2009, 02:49 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