Forum Stats

  • 3,853,749 Users
  • 2,264,264 Discussions
  • 7,905,440 Comments

Discussions

Categories

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

· Share on TwitterShare on Facebook

Answers

  • Sdhamoth-Oracle
    Sdhamoth-Oracle Member Posts: 189 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

    · Share on TwitterShare on Facebook
  • 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.

    · Share on TwitterShare on Facebook
This discussion has been closed.