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

I am Sanjay's colleague.

I have tried querying from the two tables specified. That still comes back with the same error.

There is not property on the Link Server called "Allow InProc". How can I set this property?

Any suggestions?

Punita

Where can I find the "Allow InProc" property? Is it in the definition of the linkded server in SQL Server or on the Oracle OLE DB provider? Or somewhere else? I can't find a place to set it.

Ralph

Sinclar,

Thanks very much for detailed response. I could only modify the properties if I re-added the server the Provider Options button was grayed out on existing links so that's probably why I didn't look there.

Ralph

Thanks. This helps me resolve me prb too.

This has also resolved my issue with the same error msg. However, I was using SQL Server2000 and the properties were not modifiable for an existing linked server. The way around this is to create a new one and click Provider Options in the general tab and then tick Allow InProcess.