Results 1 to 2 of 2
  1. #1
    hcuk is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2013

    ODBC connection to Oracle 11g Back-End Error (ODBC --call failed.) Pictures inside

    I am trying to link Oracle 11g tables to Microsoft access 2010, But I keep getting the odbc --call failed error.

    Click image for larger version. 

Name:	Microsoft Access.png 
Views:	18 
Size:	25.0 KB 
ID:	18788

    Here are my steps:
    1. Click on External Data tab, then go to ODBC Database.
    2. Check "Link to the data source by creating a linked table".
    3. Go to the "Machine Data Source" tab
    4. Create a new Data source -> System Data Source -> Select Microsoft ODBC for Oracle, then finish
    5. Data Source Name: TestODBC Description: Testing Username: Test Server: TestServer

    The value of Test Server is already created in the tnsnames file. I've ran a tnsping on it and it works. I'm not sure what's going on. Please advise.

  2. #2
    lfpm062010 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2013
    Did you configure your "tnsnames.ora" file?

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

Similar Threads

  1. Replies: 2
    Last Post: 01-21-2014, 11:23 AM
  2. ODBC -- Call Failed error
    By Coffee in forum Access
    Replies: 3
    Last Post: 07-08-2011, 10:34 AM
  3. Help: ODBC call failed -952 SQLSTATE 57014 error
    By accessnewbie in forum Access
    Replies: 2
    Last Post: 02-02-2011, 01:01 PM
  4. ODBC -- call failed. | Oracle ODBC
    By drdexter33 in forum Access
    Replies: 1
    Last Post: 04-03-2010, 09:32 PM
  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 - Senior Forums