| Groups | Blog | Home |
sql server connect : SQL2k - ORA connect, OLE DB provider 'MSDAORA' reported an error
in the following article: HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in SQL Server http://support.microsoft.com/?id=280106 -Sue On Fri, 7 Nov 2003 14:33:31 +0100, "msnews.microsoft.com" [quoted text, click to view] <mt@provanum.se> wrote:
>Hi, > > >I have a problem when I'm running linked servers from SQL2K Develop Edition >SP3a to Oracle 8i >with MDAC 2.7RTM. OS: WinXP SP1 > > >I get following error : > >OLE DB provider 'MSDAORA' reported an error. The provider did not give any >information about the error. >OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize >returned 0x80004005: The provider did not give any information about the >error.]. > >when I'm trying to connect to the server. > > >If I try to connect to the Oracle with NET8 and ODBC test it's working fine. > >I have reinstalled the SQL2K and reapplied the SP and tested with different >MDAC > > >Any ideas what could be wrong? > > >Thanks, > >Mikael >
Hi,
I have a problem when I'm running linked servers from SQL2K Develop Edition SP3a to Oracle 8i with MDAC 2.7RTM. OS: WinXP SP1 I get following error : OLE DB provider 'MSDAORA' reported an error. The provider did not give any information about the error. OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error.]. when I'm trying to connect to the server. If I try to connect to the Oracle with NET8 and ODBC test it's working fine. I have reinstalled the SQL2K and reapplied the SP and tested with different MDAC Any ideas what could be wrong? Thanks, Mikael
Hi Sue,
I have tried all the steps in the article.. --Mike "Sue Hoegemeier" <Sue_H@nomail.please> skrev i meddelandet news:s5fnqvs8lru4gqk8el6pipm1vq2h7mkg8r@4ax.com... [quoted text, click to view] > You may want to start by following the troubleshooting steps > in the following article: > HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in > SQL Server > http://support.microsoft.com/?id=280106 > > -Sue > > On Fri, 7 Nov 2003 14:33:31 +0100, "msnews.microsoft.com" > <mt@provanum.se> wrote: > > >Hi, > > > > > >I have a problem when I'm running linked servers from SQL2K Develop Edition > >SP3a to Oracle 8i > >with MDAC 2.7RTM. OS: WinXP SP1 > > > > > >I get following error : > > > >OLE DB provider 'MSDAORA' reported an error. The provider did not give any > >information about the error. > >OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize > >returned 0x80004005: The provider did not give any information about the > >error.]. > > > >when I'm trying to connect to the server. > > > > > >If I try to connect to the Oracle with NET8 and ODBC test it's working fine. > > > >I have reinstalled the SQL2K and reapplied the SP and tested with different > >MDAC > > > > > >Any ideas what could be wrong? > > > > > >Thanks, > > > >Mikael > > >
So after you modified the registry an enabled the trace
flag, what was the extended error information? Message number and message? -Sue On Fri, 7 Nov 2003 20:57:28 +0100, "ACE" <ACE@nospam.com> [quoted text, click to view] wrote:
>Hi Sue, > >I have tried all the steps in the article.. > >--Mike > >"Sue Hoegemeier" <Sue_H@nomail.please> skrev i meddelandet >news:s5fnqvs8lru4gqk8el6pipm1vq2h7mkg8r@4ax.com... >> You may want to start by following the troubleshooting steps >> in the following article: >> HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in >> SQL Server >> http://support.microsoft.com/?id=280106 >> >> -Sue >> >> On Fri, 7 Nov 2003 14:33:31 +0100, "msnews.microsoft.com" >> <mt@provanum.se> wrote: >> >> >Hi, >> > >> > >> >I have a problem when I'm running linked servers from SQL2K Develop >Edition >> >SP3a to Oracle 8i >> >with MDAC 2.7RTM. OS: WinXP SP1 >> > >> > >> >I get following error : >> > >> >OLE DB provider 'MSDAORA' reported an error. The provider did not give >any >> >information about the error. >> >OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize >> >returned 0x80004005: The provider did not give any information about the >> >error.]. >> > >> >when I'm trying to connect to the server. >> > >> > >> >If I try to connect to the Oracle with NET8 and ODBC test it's working >fine. >> > >> >I have reinstalled the SQL2K and reapplied the SP and tested with >different >> >MDAC >> > >> > >> >Any ideas what could be wrong? >> > >> > >> >Thanks, >> > >> >Mikael >> > >> >
Often times you get more info if you follow the suggestions
with the trace and profiler per the article but you said you already did all of those. I'd still guess that something with either the Oracle client and/or MDAC configuration isn't correct. You could try reinstalling the Oracle client, double checking the registry settings (and registry permissions) and check your MDAC configuration with component checker. You can download component checker from: http://msdn.microsoft.com/downloads/list/dataaccess.asp -Sue On Mon, 10 Nov 2003 11:35:48 +0100, "mt@provanum.se" [quoted text, click to view] <mt@provanum.se.no.mail> wrote:
>Hi, > >Sorry for the different signatures.. > > >On trace I got following errors: > >Exception Error: 208, Severity: 16, State: 1 MS SQLEM sa 1744 54 >2003-11-10 11:25:12.863 > >OLEDB Errors >OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: >The provider did not give any information about the error. MS SQLEM sa >1744 54 2003-11-10 11:25:53.463 > >Exception: >Error: 7399, Severity: 16, State: 1 > >Should it be more information? Have I missed something? > >Best Regards > > >Mikael > > > >"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message >news:rissqvkrkv4016gn9nmq7j08j5uu5k869e@4ax.com... >> So after you modified the registry an enabled the trace >> flag, what was the extended error information? Message >> number and message? >> >> -Sue >> >> On Fri, 7 Nov 2003 20:57:28 +0100, "ACE" <ACE@nospam.com> >> wrote: >> >> >Hi Sue, >> > >> >I have tried all the steps in the article.. >> > >> >--Mike >> > >> >"Sue Hoegemeier" <Sue_H@nomail.please> skrev i meddelandet >> >news:s5fnqvs8lru4gqk8el6pipm1vq2h7mkg8r@4ax.com... >> >> You may want to start by following the troubleshooting steps >> >> in the following article: >> >> HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in >> >> SQL Server >> >> http://support.microsoft.com/?id=280106 >> >> >> >> -Sue >> >> >> >> On Fri, 7 Nov 2003 14:33:31 +0100, "msnews.microsoft.com" >> >> <mt@provanum.se> wrote: >> >> >> >> >Hi, >> >> > >> >> > >> >> >I have a problem when I'm running linked servers from SQL2K Develop >> >Edition >> >> >SP3a to Oracle 8i >> >> >with MDAC 2.7RTM. OS: WinXP SP1 >> >> > >> >> > >> >> >I get following error : >> >> > >> >> >OLE DB provider 'MSDAORA' reported an error. The provider did not give >> >any >> >> >information about the error. >> >> >OLE DB error trace [OLE/DB Provider 'MSDAORA' >IDBInitialize::Initialize >> >> >returned 0x80004005: The provider did not give any information about >the >> >> >error.]. >> >> > >> >> >when I'm trying to connect to the server. >> >> > >> >> > >> >> >If I try to connect to the Oracle with NET8 and ODBC test it's working >> >fine. >> >> > >> >> >I have reinstalled the SQL2K and reapplied the SP and tested with >> >different >> >> >MDAC >> >> > >> >> > >> >> >Any ideas what could be wrong? >> >> > >> >> > >> >> >Thanks, >> >> > >> >> >Mikael >> >> > >> >> >> > >> >
Hi,
Sorry for the different signatures.. On trace I got following errors: Exception Error: 208, Severity: 16, State: 1 MS SQLEM sa 1744 54 2003-11-10 11:25:12.863 OLEDB Errors OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error. MS SQLEM sa 1744 54 2003-11-10 11:25:53.463 Exception: Error: 7399, Severity: 16, State: 1 Should it be more information? Have I missed something? Best Regards Mikael [quoted text, click to view] "Sue Hoegemeier" <Sue_H@nomail.please> wrote in message news:rissqvkrkv4016gn9nmq7j08j5uu5k869e@4ax.com... > So after you modified the registry an enabled the trace > flag, what was the extended error information? Message > number and message? > > -Sue > > On Fri, 7 Nov 2003 20:57:28 +0100, "ACE" <ACE@nospam.com> > wrote: > > >Hi Sue, > > > >I have tried all the steps in the article.. > > > >--Mike > > > >"Sue Hoegemeier" <Sue_H@nomail.please> skrev i meddelandet > >news:s5fnqvs8lru4gqk8el6pipm1vq2h7mkg8r@4ax.com... > >> You may want to start by following the troubleshooting steps > >> in the following article: > >> HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in > >> SQL Server > >> http://support.microsoft.com/?id=280106 > >> > >> -Sue > >> > >> On Fri, 7 Nov 2003 14:33:31 +0100, "msnews.microsoft.com" > >> <mt@provanum.se> wrote: > >> > >> >Hi, > >> > > >> > > >> >I have a problem when I'm running linked servers from SQL2K Develop > >Edition > >> >SP3a to Oracle 8i > >> >with MDAC 2.7RTM. OS: WinXP SP1 > >> > > >> > > >> >I get following error : > >> > > >> >OLE DB provider 'MSDAORA' reported an error. The provider did not give > >any > >> >information about the error. > >> >OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize > >> >returned 0x80004005: The provider did not give any information about the > >> >error.]. > >> > > >> >when I'm trying to connect to the server. > >> > > >> > > >> >If I try to connect to the Oracle with NET8 and ODBC test it's working > >fine. > >> > > >> >I have reinstalled the SQL2K and reapplied the SP and tested with > >different > >> >MDAC > >> > > >> > > >> >Any ideas what could be wrong? > >> > > >> > > >> >Thanks, > >> > > >> >Mikael > >> > > >> > > >
Hi,
I am getting exactly the same error. I think it may be a problem with service pack 3a. Did you get to resolve this ? Thanks, Chandra. [quoted text, click to view] >-----Original Message-----
>Hi, > > >I have a problem when I'm running linked servers from SQL2K Develop Edition >SP3a to Oracle 8i >with MDAC 2.7RTM. OS: WinXP SP1 > > >I get following error : > >OLE DB provider 'MSDAORA' reported an error. The provider did not give any >information about the error. >OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize >returned 0x80004005: The provider did not give any information about the >error.]. > >when I'm trying to connect to the server. > > >If I try to connect to the Oracle with NET8 and ODBC test it's working fine. > >I have reinstalled the SQL2K and reapplied the SP and tested with different >MDAC > > >Any ideas what could be wrong? > > >Thanks, > >Mikael > > >.
Yes,
but I have to reinstall it all.. I think you are right about the SP I think I'm running on a lower NDAC right now.. /MT [quoted text, click to view] "Chandra" <anonymous@discussions.microsoft.com> wrote in message news:15f501c3a899$759f1b50$a601280a@phx.gbl... > Hi, > > I am getting exactly the same error. I think it may be a > problem with service pack 3a. > > Did you get to resolve this ? > > Thanks, > Chandra. > >-----Original Message----- > >Hi, > > > > > >I have a problem when I'm running linked servers from > SQL2K Develop Edition > >SP3a to Oracle 8i > >with MDAC 2.7RTM. OS: WinXP SP1 > > > > > >I get following error : > > > >OLE DB provider 'MSDAORA' reported an error. The provider > did not give any > >information about the error. > >OLE DB error trace [OLE/DB Provider 'MSDAORA' > IDBInitialize::Initialize > >returned 0x80004005: The provider did not give any > information about the > >error.]. > > > >when I'm trying to connect to the server. > > > > > >If I try to connect to the Oracle with NET8 and ODBC test > it's working fine. > > > >I have reinstalled the SQL2K and reapplied the SP and > tested with different > >MDAC > > > > > >Any ideas what could be wrong? > > > > > >Thanks, > > > >Mikael > > > > > >. > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
August 2008
| home · blog · groups | Questions? Comments? Contact the dn |