Cannot create an instance of OLE DB provider "OraOLEDB.Oracle"

  • Hi,

    Hoping someone might be able to help us with our problem, as it's got us stumped...and not managed to find a solution on any forums.

    We're trying to set up a linked server to Oracle (11.2) on a test environment and keep getting the error:

    "The linked server has been created but failed a connect test.

    Additional info:

    Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for [OURORACLEBOX]

    Microsoft SQL Server Error: 7302"

    We're working on SQL Server 2008 (R2) SP2 (10.50.4000).

    We managed to create the linked server on our Dev box, which is running exactly the same verison of SQl Server, but just can't get it to work on the Test environment.

    We can connect to the Oracle server using SQL Plus and query the DB, so our drivers seem to be OK.

    I've tried various registry tweaks and so on, but with no success.

    Any help would be very highly appreciated....

    Thanks.

  • Just in case it helps...

    If your are testing using SSMS remote and the login doesn't have enough permissions 'in windows on the SQL Server' then it will fail and look like an installation problem.

    If you look at the windows log:

    The machine-default permission settings do not grant Local Activation permission for the COM Server application with CLSID .......

    You must use a login with sufficient permissions on windows server on the SQL server.

    Really confusing.

Viewing 2 posts - 1 through 1 (of 1 total)

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