Francisco Tapia
fhtapia at gmail.com
Mon Sep 13 17:31:10 CDT 2004
I'd run the component checker on both machines and see what's diffrent.. On Fri, 10 Sep 2004 18:55:26 -0400, PaulR <paulr at zslinc.com> wrote: > Hi, > > Please help on this, thanks in advance, > > I am having very hard time to get the connecting between SQLServer 2000 and > Oracle 8.1.7 using Linked Server, always I am getting the same error message > . > > Error: 7933: OLE DB Provider 'MSDAORA' reported an Error, > > The Error Occurred while connecting to oracle from SQLServer 2000 in WINDOWS > 2003, I have tried with MDAC > 2.8, MDAC 2.7 and restarted the Server, nothing is working. We are always > getting the Same Error > > Error 7399: OLE DB Provider 'MSDAORA' Reported an error. > OLE DB error trace [OLE/DB Provider 'MSDAORA' > IDBInitialize::Initialize returned 0x80004005: ]. > > But I tried with one of the Windows 2000 machine, its working fine, Please > help... > > Please help thanks > Paul > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > -- -Francisco