Error 7399: OLE DB provider 'MSDAORA' reported an error."

[ha1ls45]

Hi all,
I am having problems connecting my SQL Server to an Oracle Database via a Linked Server. I have Oracle 9i installed . The SQL Server is Microsoft 2003 with Service Pack 1.

The error I get is:

Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ].

My Register Keys are set at:
OracleOciLib = ociw32.dll
OracleSqlLib = SQLLib18.dll
OracleXaLib = xa73.dll

I have created an ODBC connection to this Oracle Server.

The Linked Server I am trying to create has this info:
Data Source = MyServer
Provider String = MSDAORA
Provider Name = Microsoft OLE DB Provider for Oracle

I was able to successfully do a TNSPING via the command prompt and it returned "OK".

Any suggestions?? This is frusterating!!! :-[

Thanks,
Ha1ls45

 

[aalmeida]

Do you have the Oracle *NET ODBC drivers, the default microsoft drivers also require the tsnames to be set and to have it you need to dowload the stuff from oracle and you can start looking for at:

http://www.oracle.com/technology/software/products/database/oracle10g/index.html

they should be backwards compatible to erlier versions of the oracle Xi databases.

AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"