> Hello together,
>
> I'm trying to connect a SQL-Server 2000 to an Oracle 9i through a
> linked Server.
>
> For this I'm using the enterprise manager.
>
> I managed to do it if the oracle server is located on a different
> machine than the sql server. Unfortunately if both server are on the
> same machine i get the following error when I try to see the list of
> tables or views.
> Error 7399: OLE DB Provider 'MSDAORA' Reported an error. OLE DB error
> trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned
> 0x80004005: ].
> I installed service pack 3a for sql-server, MDAC 2.7 sp1 refresh and
> the 9.2.0.3 patch for oracle. I verified the name of the TNS-Listener.
> I tried also via the addlinkedserver stored procedure but nothing
> helps.
>
> TIA for any help,
> Marc
>
>
>
>
>

MS Sql Server LazyDBA home page