Hello,

I am working with a SQL Server 2000 DTS, this DTS should extract data from
Oracle (version 8.1), and it also make one Update into that Oracle Database,
The Dts is working fine, but the database server are on different locations
and the network some times fails. Because of it i try to use DTC in order to
make all the DTS transacctional (if something fails rollover everything).
The problem i had when i try to run the DTS is that in the task that update
Oracle Database y show me the followin error:
The operation could not be performed because the OLE DB provider 'MSDAORA'
does not support distributed transactions. OLE DB error trace [OLE/DB
Provider 'MSDAORA' ITransactionJoin::JoinTransaction returned 0x8004d01b]
I looked at the microsoft knowledge database and found the article 280106
(http://support.microsoft.com/default...;en-us;Q280106
)

I apply the configuration of that article and i am having the same error the
MtxOCI.dll that the article refers seem to be up, because i can see it on
the system information (i do not know another way to be sure it is running).

Currently ai am woking on Wiindows XP client machine but the sql server is
installed on Windows 2000, both are updated with SP.
Sql reports the following version: Microsoft SQL Server 2000 - 8.00.760
(Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft
Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack
4)
Oracle is version 8.1

What else can i try?

Thanks in advance
Carlos Mauricio Parra



************* SPANISH VERSION JUST IN CASE ****************************
Hola:

Estoy trabajndo con un DTS de SQL Server 2000, el cual debe traer datos de
Oracle pero a la vez debe hacer uno que otro Update o insert en Oracle.
Me esta funcionando bien, pero como los servidores esten en locaciones
distintas (a mas de 30 Km) en ocaciones hay fallas con la conexión y me
queda la base de datos llena de basura.
Estoy tratando de crear una trasaccion utilizando el DTC, lo cual me
funciona a las mil maravillas hasta que actualizo algo en Oracle, que me da
el siguiente error:

Busque en la base de conocimientos y encontre el articulo 280106:

http://support.microsoft.com/default...;en-us;Q280106



lo aplique, haciendo los cambios en el regitro. Inclusive veo la librería
que ellos mencionan (MtxOCI.dll ) en el system info.

estoy trabajando en mi Pc con windows XP pero el servidor donde esta
instalado es Windows 2000

mi version exacta del sql es :

Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
NT 5.0 (Build 2195: Service Pack 4)

ORACLE es version 8.1

y tengo actualizado el MDAC.

que mas puedo hacer



de antemano Gracias,

Carlos Mauricio Parra

Could you add a few steps to the begining of the DTS to do some arbitory
select on all servers involved. ie Select Getdate() from the SQL Servers and
the same on the Oracle boxes. Using DTS Workflow ensure all the Selects
work, if they did then continue as all servers are available if any didn't
response quit with failure before any of the data manipulation has happened.

--
HTH
Ryan Waight, MCDBA, MCSE

"Carlos Mauricio Parra" <cparra (AT) cipher (DOT) com.ve> wrote