Connectivity fails to remote Oracle linked server

I have linked an oracle remote database from MS SQL server 2000, connecting
an Oracle 8.1.7 database. The linked worked fine for a few days but fails
now with a message 'Error 7399:OLE DB provider 'MSDAORA' reported an error.
OLE DB error trace [OLE DB Provider 'MSDAORA' DBInitialize::Initialized
returned 0x80004005. ]. The version of MSDAORA.DLL being used is 4.71. Any
ideas where the problem might be? I can connect to Oracle database from SQL
server via sql+.That's a generic error. Try turning on trace flag 7300 or
us SQL Profiler to capture the OLEDB Errors event. This
should give you to get more information about the error.
Additionally, you'll want to check 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 Sun, 18 Jul 2004 21:59:55 GMT, "Javed"
<purdaysee@.hotmail.com> wrote:

>I have linked an oracle remote database from MS SQL server 2000, connecting
>an Oracle 8.1.7 database. The linked worked fine for a few days but fails
>now with a message 'Error 7399:OLE DB provider 'MSDAORA' reported an error.
>OLE DB error trace [OLE DB Provider 'MSDAORA' DBInitialize::Initialized
>returned 0x80004005. ]. The version of MSDAORA.DLL being used is 4.71. Any
>ideas where the problem might be? I can connect to Oracle database from SQL
>server via sql+.
>|||I have the same setup. Friday 07/30/2004 the linked server started to fail w
ith the same message you are getting. We are looking into some OS security p
atches that were installed as the possible problem. Specifically MS04-020 an
d MS04-024. No resolution y
et.
Have you found the problem?
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...