Hi,

Oracle client is installed and TNSNAME.ORA is available on the SQL Server where I'd like to create linked server.

The Oracle provider is "Oracle Provider for OLE DB"
Product name is "OraOLEDB.Oracle"

After creating the Oracle Linked server, I tried a simple select statement by 4 part full qualified name as below.

select * from OraDB..Schema.TBName

I am getting follwoing error message.

Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES" for OLE DB provider "OraOLEDB.Oracle" for linked server "OraDB". The provider supports the interface, but returns a failure code when it is used.

But it works for OPENQUERY. It looks for me that in some situation, 4 part full qualifier name doesnt work while openquery works.

Could someone please advise the reason?

Thanks