server to Oracle -OLE/DB Provider 'MSDAORA' IDBInitialize

Hi All
We have a WIN NT 4.0 Server with SQL 7.0 (7.00.961) Connecting to Oracle 8 DB using linked server . With Trace flag 7300 on we get an error message as follows.We are using Oracle 9 i Clien
Thank you , Shaj
DBCC execution completed. If DBCC printed error messages, contact your system administrator
Server: Msg 7399, Level 16, State 1, Line
OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider returned message: An Oracle Error occured, but message could not be determined
OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ]provide product name as oracle.give tnsname for the db
which you are trying to connect as datasource..
in the security tab give remote user.password appropriate
for the db which you are trying to connect..this will
resolve your issue
>--Original Message--
>Hi All ,
>We have a WIN NT 4.0 Server with SQL 7.0 (7.00.961)
Connecting to Oracle 8 DB using linked server . With Trace
flag 7300 on we get an error message as follows.We are
using Oracle 9 i Client
>Thank you , Shaji
>DBCC execution completed. If DBCC printed error messages,
contact your system administrator.
>Server: Msg 7399, Level 16, State 1, Line 1
>OLE DB provider 'MSDAORA' reported an error.
>[OLE/DB provider returned message: An Oracle Error
occured, but message could not be determined]
>OLE DB error trace [OLE/DB Provider 'MSDAORA'
IDBInitialize::Initialize returned 0x80004005: ].
>.
>|||We use MS OLE DB Provider for Oracle with following parameter
Product name : Oracl
Data Source : DEVP
Provider string :MSDAORA
With relevant Remote user name and Password . The issue still remain the same. :
Thank you for the fast respons
Shaj|||With it being an initialization error, you may want to make
sure the provider is registered - try registering
msdora.dll. If you get any errors, try reinstalling mdac.
You may also want to refer to the following:
HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in
SQL Server
http://support.microsoft.com/?id=280106
-Sue
On Tue, 20 Apr 2004 00:41:02 -0700, "Shaji"
<anonymous@.discussions.microsoft.com> wrote:
>We use MS OLE DB Provider for Oracle with following parameters
>Product name : Oracle
>Data Source : DEVP
>Provider string :MSDAORA
>With relevant Remote user name and Password . The issue still remain the same. :(
>Thank you for the fast response
>Shaji
>