MTS is not managing my transactions with Informix

[HugoLeitao]

Hi,

I've developed a MTS component that performs the
follwing operations:
- get the Context.
- establishes a connection to Informix Server 7.31.UC5.
- execute an update statment.
- close the connection.
- Set the context to setcomplete.

What's the problem ?
Well the MTS isn't managing transactions.
I've debuged the component and I've set a break point
after the execute statment.
From another application and making sure that the isolation
level isn't set to dirty read I was able to see the update.
it seems that MTS isn't managing transactions or that any
statment it's auto-commited.

My question ?
Does anyone know how to make the MTS the transaction coordinator for a Informix Server ?

Tanks for further help
Hugo Leitão

 

[Mike42]

You will have to use the Informix ODBC driver to get this combination to work. As far as I know the Informix OLEDB driver does not support MTS Transactions, but the MS OLEDB for ODBC driver in combination with Informix ODBC will do.

Try to get a recent ODBC driver (3.33 or 3.34) as it seems that Informix is currently modifying the support for distributed transactions.

But even there are several Problems with this combination I have not yet further investigated.

 

[HugoLeitao]

Hi Mike42,

first ... how do I vote for you to the Top Expert
completion ?

In this problem I was using the Informix ODBC
and like you said it ( correctly ) the Informix
ODBC supports transactions.

But my problem was that when you debug a
component running in MTS and the backend
it's a Informix Server, you MUST Shut Down
your package first to be able to debug.
I know that this may sound strange but I've
tested thousands of components in the MTS
environment with the SQL server as backend
and I never had this problem.

Once more tanks for your answer.
Best wishes
Hugo
P.S For now all tests are running fine,
if I found a problem I'll let you know.