LinkedServer Failure to connect Oracle 8.1.7

The Error Occured 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...
Thanks in advance, NEED URgent HELP, Whole project gets
stopped because of THIS.
Thanks
Paul
I have the same problem.
If you find the solution, please post the message here.
Thanks.
Vlado
"Paul" <Paulr@.fieldpower.com> wrote in message
news:024501c49781$0fa9fb30$a501280a@.phx.gbl...
> The Error Occured 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...
> Thanks in advance, NEED URgent HELP, Whole project gets
> stopped because of THIS.
> Thanks
> Paul
|||Try turning on trace flag 7300 to get a more detailed error
message. In Query Analyzer, execute the following:
Dbcc traceon (7300,3604)
and then try executing a query against oracle.
-Sue
On Fri, 10 Sep 2004 14:56:44 -0700, "Paul"
<Paulr@.fieldpower.com> wrote:

>The Error Occured 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...
>Thanks in advance, NEED URgent HELP, Whole project gets
>stopped because of THIS.
>Thanks
>Paul
|||I am also having the same problem on a Windows 2003 box and can't find a
resolution ANYWHERE!!!!! Linked Oracle Server on Windows 2000 box has been
working great all along. Come on Microsoft - what is the story? I have
seen hundreds and hundred of posts on this issue with no known resolution.
This is a widely used functionality. Anyone out there overcome it??
"Paul" wrote:

> The Error Occured 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...
> Thanks in advance, NEED URgent HELP, Whole project gets
> stopped because of THIS.
> Thanks
> Paul
>
|||I just opened a crit sit with MS to get the answer to this. Here is the
fix with Windows 2003, SQL 2000, and Oracle 9i:
This is discussed in Q193893 and according to this the registry key "
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOC I] " should have
following
entries.
"OracleXaLib"="oraclient9.dll"
"OracleSqlLib"="orasql9.dll"
"OracleOciLib"="oci.dll"
I hope this helps.
Carrie
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!