My Oracle Support Banner

Creating a Linked Server Between Oracle & Sql Server 2005 Fails with Msg 7311 (Doc ID 363213.1)

Last updated on MARCH 04, 2022

Applies to:

Oracle Provider for OLE DB - Version and later
Microsoft Windows (32-bit)
Microsoft Windows Itanium (64-bit)
Microsoft Windows x64 (64-bit)


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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.