New tip...

I ran across this article on passing a variable to an openquery a while back...

http://www.sqljunkies.com/How%20To/BA89A311-B3AE-4803-BABA-64FCF1E1F8F7.scuk

...and recently had the need to use the...

You're right David. Sorry, I missed the SQL logon failure part. Could it be you are running out of memory to support new connections?

I see this problem any time my SQL Server looses contact with a Domain Controller (it doesn't switch to another DC, either). Also as Vladan suggested, if you are running SQL...

I always assumed the literal effect of the quoted query would nix that idea. Let me know if you get it to work. Probably have to switch back to linked...

...doesn't seem to like the column name. Is ID a reserved word in Oracle? Try quoting it.

Should work, unless in you try to wrap it in a transaction, which the provider doesn't support. Good luck.

We don't run Reporting Services, but we do quite a bit of heterogeneous queries against Oracle DBs.

I don't use the Oracle OLEDB for Linked Servers, because I don't believe it's...