MS SQL Server - SQL 2000 Linked Server...

Author

SQL 2000 Linked Server...

Luca Fabbri

2006-03-24, 7:26 am

Good morning.
I have Windows 2003 Advanced Server with SP1 and Clustered SQL Server 2000
with SP3. I need to use Linked Server to connect to Oracle 9i database. So I
installed on each node Oracle Network Utilities. After setup Linked Server
(by using Microsoft OLE DB Provider for Oracle) and I try to launch an
Openquery from query analyzer I get this error:
--------------------------------
Server: Msg 7399, Level 16, State 1, Line 3
OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider returned message: Oracle client and networking components
were not found. These components are supplied by Oracle Corporation and are
part of the Oracle Version 7.3.3 or later client software installation.

Provider is unable to function until these components are installed.]
OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initi
alize
returned 0x80004005: ].
--------------------------------
This error normally appears when the package "Network utilities" isn't
installed but I installed it on each node....do I need to setup or check some
other feature ?!?

Thank you a lot for support.

Bye, Luca Fabbri

John Bell

2006-03-26, 8:23 pm

Hi Luca

I am not an expert on this, but http://support.microsoft.com/kb/220915
suggests installing on each node should work. Have you verified that you the
networking utilities are configured correctly and working?

http://support.microsoft.com/kb/306212 suggests setting DBCC TRACEON (3604,
7300)

You may also want to check that DTC is installed and working correctly.

John

"Luca Fabbri" wrote:

> Good morning.
> I have Windows 2003 Advanced Server with SP1 and Clustered SQL Server 2000
> with SP3. I need to use Linked Server to connect to Oracle 9i database. So I
> installed on each node Oracle Network Utilities. After setup Linked Server
> (by using Microsoft OLE DB Provider for Oracle) and I try to launch an
> Openquery from query analyzer I get this error:
> --------------------------------
> Server: Msg 7399, Level 16, State 1, Line 3
> OLE DB provider 'MSDAORA' reported an error.
> [OLE/DB provider returned message: Oracle client and networking components
> were not found. These components are supplied by Oracle Corporation and are
> part of the Oracle Version 7.3.3 or later client software installation.
>
> Provider is unable to function until these components are installed.]
> OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initi
alize
> returned 0x80004005: ].
> --------------------------------
> This error normally appears when the package "Network utilities" isn't
> installed but I installed it on each node....do I need to setup or check some
> other feature ?!?
>
> Thank you a lot for support.
>
> Bye, Luca Fabbri
>

Sponsored Links