Linked Server for Oracle XE Database

Hello,
I have been able to create a linked server using the MSDAORA provider to an
Oracle XE Server. I have done so on the same machine as the Oracle XE
Server (also has a SQL server on it), and on another machine (with SQL
server and Oracle XE Client installed). The problem happens when I have do
anything to the Oracle database within a transaction. You see in order to
get this to work you need to point the MSDTC (Microsoft Distributed
Transaction Coordinator) to the correct Oracle DLLs. You can do this by
modifying the registry entries at the following location:
HKLM\Software\Microsoft\MSDTC\MTxOCI\
I could do so on the server with Oracle XE Server installed. I entered the
following values:
OracleOciLib = oci.dll
OracleSqlLib = orasql10.dll
OracleXaLib = oraclient10.dll
And everything worked fine. But on the server with the Oracle XE Client
installed, these files are not present, so what am I supposed to do? I
tried copying the files from the Oracle XE Server PC but it didn't fix
things. Has anyone had any success in configuring MSDTC for Oracle XE
Client?
Any help would be greatly appreciated.
Thanks.
-adamOkay, I have gotten around it by installing the Oracle 8i Client on the
server instead of the Oracle XE Client. This is hardly ideal, but it will
have to do until I can find a solution.
-adam
"Adam Byrne" <misterbyrne.nospam@.allforme.gmail.com> wrote in message
news:e3u5JVwjGHA.3440@.TK2MSFTNGP02.phx.gbl...
> Hello,
> I have been able to create a linked server using the MSDAORA provider to
> an Oracle XE Server. I have done so on the same machine as the Oracle XE
> Server (also has a SQL server on it), and on another machine (with SQL
> server and Oracle XE Client installed). The problem happens when I have
> do anything to the Oracle database within a transaction. You see in order
> to get this to work you need to point the MSDTC (Microsoft Distributed
> Transaction Coordinator) to the correct Oracle DLLs. You can do this by
> modifying the registry entries at the following location:
> HKLM\Software\Microsoft\MSDTC\MTxOCI\
> I could do so on the server with Oracle XE Server installed. I entered
> the following values:
> OracleOciLib = oci.dll
> OracleSqlLib = orasql10.dll
> OracleXaLib = oraclient10.dll
> And everything worked fine. But on the server with the Oracle XE Client
> installed, these files are not present, so what am I supposed to do? I
> tried copying the files from the Oracle XE Server PC but it didn't fix
> things. Has anyone had any success in configuring MSDTC for Oracle XE
> Client?
> Any help would be greatly appreciated.
> Thanks.
> -adam
>