DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Problem with linked server to Oracle

506350May 15 2006 — edited Aug 27 2009

Hello.
I have the following problem:
I set up a linked server in SQL Server 2000 to Oracle with Oracle OLEDB provider. I see all the tables in the linked server so the connection is successful but when I tried to select from some remote table, most often I get the following error:
Server: Msg 7356, Level 16, State 1, Line 1
OLE DB provider 'OraOLEDB.Oracle' supplied inconsistent metadata for a column. Metadata information was changed at execution time.
MOREOVER, selecting from some of the tables, returns other errors:
* Server: Msg 7320, Level 16, State 2, Line 1
Could not execute query against OLE DB provider 'OraOLEDB.Oracle'.
or:
Server: Msg 7317, Level 16, State 1, Line 1
OLE DB provider 'OraOLEDB.Oracle' returned an invalid schema definition.
All these errors are very strange to me!

I set up a linked server to the same Oracle database but with Microsoft OLE DB provider for Oracle. And everything just works perfect! (I would use this provider but it does not support distributed transactions so I can't do all my job.)

I just can't understand why the Oracle OLEDB provider is not working properly.

The same situation is happening with another PC in different LAN, with different SQL server, different Oracle database and so on.

Any help will be appreciated! Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 24 2009

Added on May 15 2006

#db, #oracle-provider-for-ole-db, #windows-and-net

7 comments

33,543 views