Last updated on MAY 25, 2012
Applies to:Oracle Provider for OLE DB - Version 18.104.22.168 and later
Microsoft Windows (32-bit)
Microsoft Windows Itanium (64-bit)
Microsoft Windows x64 (64-bit)
***Checked for relevance on 25-May-2012***
Creating a Linked Server fails with:
Msg 7311, Level 16, State 2, Procedure sp_tables_ex, Line 41
Cannot obtain the schema rowset "DBSCHEMA_TABLES" for OLE DB provider "SQL Server" for linked
server "(null)". The provider supports the interface, but returns a failure code when it is used.
SQL Plus can make a successful connection to the database as well as the Oracle Provider for OLEDB using a UDL File.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms