-
Linked Server from SQL Server 2005 to Oracle
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|