InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 18:31:19 GMT20http://www.sqlservercentral.com/Forums/Topic482481-146-1.aspxThanks John, I was stuck with the same issue, your recommendation got me through.Wed, 01 May 2013 12:13:39 GMTjohn.saldanhahttp://www.sqlservercentral.com/Forums/Topic482481-146-1.aspxThanks, worked like a charm !Thu, 03 Jan 2013 01:12:19 GMTa.istratehttp://www.sqlservercentral.com/Forums/Topic482481-146-1.aspxThanks. It addressed my problemFri, 13 Apr 2012 09:32:58 GMTrderisala1http://www.sqlservercentral.com/Forums/Topic482481-146-1.aspx[quote][b]John Morrelles-204026 (7/1/2008)[/b][hr]Existing linked servers will not pick up the provider setting, so new linked server objects will have to be created. But the new ones work.[/quote]Ah, that was my issue; I added the option after creating the linked server...after deleting it and re-adding it, my problem went away.thanks for the great catch.Wed, 14 Mar 2012 08:33:06 GMTEric Zierdthttp://www.sqlservercentral.com/Forums/Topic482481-146-1.aspxAbsolutely golden! Thanks for the tip; you have rescued me from hours of frustration. :-)Fri, 13 Jan 2012 07:21:08 GMTbswilshttp://www.sqlservercentral.com/Forums/Topic482481-146-1.aspxThanks, it worked for me too!!! Oh what a relief :-DTue, 28 Jun 2011 08:07:48 GMTKingCobrahttp://www.sqlservercentral.com/Forums/Topic482481-146-1.aspxThanks! me tooSun, 01 May 2011 09:09:42 GMTcodeladhttp://www.sqlservercentral.com/Forums/Topic482481-146-1.aspxThank you, this fixed the problem I too was having.Thu, 26 Feb 2009 08:31:36 GMTdaneillenhttp://www.sqlservercentral.com/Forums/Topic482481-146-1.aspxThank you for sharing this info John. This solution fixed the same issue I had.Wed, 28 Jan 2009 10:08:49 GMTDamerzhttp://www.sqlservercentral.com/Forums/Topic482481-146-1.aspxJust to follow up, a call to Microsoft support revealed that editing the Provider Properties (right-click the provider in the providers folder) and ticking the "Allow inprocess" option corrects my problem.Existing linked servers will not pick up the provider setting, so new linked server objects will have to be created. But the new ones work.Tue, 01 Jul 2008 13:07:43 GMTJohn Morrelles-204026http://www.sqlservercentral.com/Forums/Topic482481-146-1.aspxSimilar problem with SQL 2005 x64 and Oracle 11g client library. Second error message is:"Cannot get the column information from OLE DB provider "OraOLEDB.Oracle" for linked server "x".And, oddly, I get an empty result set with the column headings displayed, so the column information error message seems a little uncertain.I can connect to the Oracle server using the Oracle Provider for OLE DB in a Data Link UDL file, but that could be 32-bit. But in either case it isn't MSADORA, which was working on SQL 2000 32.Mon, 23 Jun 2008 13:39:46 GMTJohn Morrelles-204026http://www.sqlservercentral.com/Forums/Topic482481-146-1.aspxIs that login set up in linked server properties? Does by any chance that login and password for Oracle match your SQL login?PiotrThu, 10 Apr 2008 02:39:10 GMTPiotr.Rodakhttp://www.sqlservercentral.com/Forums/Topic482481-146-1.aspxThanks for the response. I am using a different username and password to authenticate to Oracle and it is not a sql login or windows login. ThanksBhavanaWed, 09 Apr 2008 12:22:03 GMTBhavana-251907http://www.sqlservercentral.com/Forums/Topic482481-146-1.aspxOpen properties of the linked server and look on the Security tab. There on the bottom of dialog, there are four options related to connection credentials. If you have selected "Be made using the login's current security context" I believe Oracle will not authenticate you as most likely it does not support Windows authentication. But this is my guess only.HTHPiotrWed, 09 Apr 2008 11:01:34 GMTPiotr.Rodakhttp://www.sqlservercentral.com/Forums/Topic482481-146-1.aspxHi,I am having this weird problem with Oracle linked server on SQL 2005 x64. I have installed Oracle client and 64bit oracle odbc drivers. If I run the below query with Windows authentication it is giving me the below error. But surprisingly if I run it as SQL Account it is running perfectly fine without any errors. I think the error message is misleading but I can't think of a reason why the linked server would work for SQL Account and not for Windows authentication.Any ideas?Query:SELECT USR_LGN_CD, USR_STS_INDFROM OPENQUERY(cwcin11d,'SELECT * FROM ccwas_usr' )Error:Msg 7399, Level 16, State 1, Line 1The OLE DB provider "OraOLEDB.Oracle" for linked server "cwcin11d" reported an error. Access denied.Msg 7332, Level 16, State 2, Line 1Cannot rescan the result set from OLE DB provider "OraOLEDB.Oracle" for linked server "cwcin11d". Unknown provider error.ThanksBhavanaWed, 09 Apr 2008 10:21:29 GMTBhavana-251907