Forum Stats

  • 3,814,855 Users
  • 2,258,920 Discussions
  • 7,892,876 Comments

Discussions

ODBC Call failed

Iwawa
Iwawa Member Posts: 352
edited Nov 12, 2015 10:07AM in ODBC

Hi to All,

This is the "scenario".

  1. On server windows 2003 is installed Oracle DB 10gR2 32 bit with a database.
  2. On Client Windows 10 64 bit I have installed Oracle Client 12c 64 bit
  3. On this client I have created an User DSN and the connection Test is succefull.

Now I try to connect a new Access DB using External Link with the ODBC DNS created, but this message is displayed "ODBC: call failed"

Have You an idea?

Thank You and Best Regards

Answers

  • Sdhamoth-Oracle
    Sdhamoth-Oracle Member Posts: 184 Employee
    edited Nov 1, 2015 1:29PM

    Hi,

    Please check whether the installed MS Office (MS Access) is 32bit or 64bit version. It should be 64bit version in case Oracle Client 12c 64bit

    Also please note that Windows 10 is not yet certified with RDBMS 12c.

    Thanks & Regards,

    Senthil

  • vansul
    vansul Member Posts: 438
    edited Nov 12, 2015 10:07AM

    there may be blocking of ports over your firewall or security policies.

    the odbc test is successfull mean the client side its ok

    you are not able to get the data via the desired port due to policies constraints or due to improper configuration at server side.

This discussion has been closed.