×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

MTS is not managing my transactions with Informix

MTS is not managing my transactions with Informix

MTS is not managing my transactions with Informix

(OP)

 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

RE: MTS is not managing my transactions with Informix

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.

RE: MTS is not managing my transactions with Informix

(OP)

 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.



Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close