Link Server between Oracle and SQL Server error

This message appears :
"Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error trace
[OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005
: ]."
My server is a Windows 2000 Server SP4, with SQLServer Enterprise SP3a.
Oracle client 7.3.3.5.0 had been installed. When I use SQL Plus 3.3 (Little
tool installed with Oracle client) it connects correcty to Oracle Database.
Unfortunatelly, when I want create a "linked server" and I click on "tables"
this message appears !?
Who can help me ?Oracle doesn't support 7.x anymore, or 8x for that matter. Are you sure
you're running 7.x?
"Olivier TACKELS" wrote:

> This message appears :
> "Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error tra
ce
> [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x800040
05: ]."
> My server is a Windows 2000 Server SP4, with SQLServer Enterprise SP3a.
> Oracle client 7.3.3.5.0 had been installed. When I use SQL Plus 3.3 (Littl
e
> tool installed with Oracle client) it connects correcty to Oracle Database
.
> Unfortunatelly, when I want create a "linked server" and I click on "table
s"
> this message appears !?
> Who can help me ?
>|||You not only have an Oracle issue, there is also an MDAC issue. I have seen
that and similar issues when upgrading from MDAC 2.2-5 to MDAC2.6-7.
MS's Oracle drivers and interfaces are based on Oracle 8.1.7.6 from MDAC 2.5
on. Your client MDAC needs to be in sync with your db server mdacs.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"fnguy" wrote:
[vbcol=seagreen]
> Oracle doesn't support 7.x anymore, or 8x for that matter. Are you sure
> you're running 7.x?
> "Olivier TACKELS" wrote:
>|||Additional thought:
What release is your Oracle database? The 10g ones won't even talk to
Oracle 7x (or 8.0.x). If your Oracle is 10g, then you definitely need to
look at MDAC and SQL*NET.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"fnguy" wrote:
[vbcol=seagreen]
> Oracle doesn't support 7.x anymore, or 8x for that matter. Are you sure
> you're running 7.x?
> "Olivier TACKELS" wrote:
>