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!

SQL Server Link Server issue.

47805Feb 2 2004 — edited May 20 2004

Hi,

I have setup a linked sql in SQL Server 2000 to connect to an Oracle 9i database. When I try to select from a table through the link server I get the following error message.

Could not execute query against OLE DB provider 'OraOLEDB.Oracle'.
OLE DB error trace [OLE/DB Provider 'OraOLEDB.Oracle' ICommandText::Execute returned 0x80040155].

This is for a table without any nvarchar2 columns (I get a different error for tables containing those datatypes).

Any ideas?

Thanks

Sanjay

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 17 2004

Added on Feb 2 2004

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

6 comments

14,500 views