Create Linked Server from 64-Bit SQL Server to Oracle

  • Hello together,

    there have been several topics about this issue but i could not find a solution for my problem.

    Server: 64 Bit

    Sql Server: 64 Bit

    Oracle Client: 64 Bit Instant Client with 64 Bit ODBC driver

    After manipulating the registry we could finally see the "Oracle in instantclient10_2" Driver in the Driver list under "Administrative Tools\ODBC Connection". Test Connection gives positive feedback.

    Now i am facing two problems:

    1. Which provider should be used in SQL Server so i can connect to oracle? At the moment i only see "Oracle Provider for OLE DB". But for what reason did i install a odbc driver when i can only select ole db in sql server?

    2. When trying to access the database from a tool like toad the error message appears "Cannot Load oci.dll".

    Can someone help me, or am i doing something completely wrong?

    3. Which provider in combination with which driver should be used?

    Thanks a lot,

    David

Viewing post 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply