none
Linked server error. Oracle from SQL Server RRS feed

  • Question

  • Hi,

    I am trying to access Oracle database from SQL Server.
    I installed ODAC also in source machine.
    Created the Linked server in SQL Server Source server below.

    Exec sp_addlinkedserver 'Test',Oracle,'OraOLEDB.Oracle','Oracedbservername:Port/OracleDB'

    In Test Properties : Server Objects: I checked The "Use Remote Collection" to True.

    Security : selected "Be made using this security context: Gave Remote login and password.

    When i am testing the connection getting the error con not create n instance of OLEDB provider 'OraOLEDB.Oracle' for inked server "Test".(error:7302)

    Please help me to resolve the issue. Its urgent.

    Thanks,


    pols

    Monday, June 24, 2019 5:57 AM

All replies

  • Hi pols,

    Thanks for your post.

    From you post, I couldn't get any valuable information, such as complete error message. For how to add linked server for Oracle in SQL Server, you could follow this article to start your task.

    Link a SQL Server to an Oracle database

    Best Regards,

    Will


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, June 25, 2019 8:30 AM
    Moderator