Cannot obtain the required interface ("IID_IBSchemaRowset")

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:
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.
 
Top