Welcome to MSSQL Forum!
MSSQL Forum - Discussions about Microsoft SQL Server

You are currently viewing our community forums as a guest user. Sign up or
Having an account grants you additional privileges, such as creating and participating in discussions.

Cannot obtain the required interface ("IID_IBSchemaRowset")

Discussion in 'Business Intelligence' started by Peter Schmitz, Feb 11, 2014.

  1. Peter Schmitz

    Peter Schmitz Administrator Staff Member

    I've been attempting to connect my SQL Development box at work to Oracle lately, and it's been a real struggle. I'll see if I can document the process a bit, in case someone else ends up running into issues (Why is it so difficult to set up a connection to Oracle to begin with?).

    Today, after the so-manieth Oracle client install, and tweaking some settings the Linked Server I originally created (using MSDASQL) suddenly ceased to work with the following error message:

    Code (text):
    Cannot obtain the required interface("IID_IDBSchemaRowset") from OLE DB Provider "OraOLEDB.Oracle" for linked server "<servername>". (MS SQL Server Error 7399).
    The solution was luckily rather simple. From within SQL Server Management Studio (SSMS), connect to your server, then expand "Server Objects", then "Linked Servers", followed by "Providers".

    Right-click "OraOLEDB.Oracle", and select "Properties".

    In the checklist, switch on "Allow inprocess". For me, that solved the error.
    farmer likes this.

Share This Page