×
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 - VB COM object Requires Transaction errors

MTS - VB COM object Requires Transaction errors

MTS - VB COM object Requires Transaction errors

(OP)
I am trying to run a VB 6.0 COM object within MTS 2.0 to retrieve data from a DB2 5.0 database. If I set the COM object's property within the MTS package to "Requires Transaction" it errors. If I set the object's property to "Does Not Support Transactions" it works fine. Any pointers on why this happens? I need to have it set to "Requires Transactions".

RE: MTS - VB COM object Requires Transaction errors

Maybe the transaction is time out.In Transaction Server Explorer right click the computer icon and swicth to option page,you can set the transaction time out value to zero.
Then you can test it again.

Hope this helps you!

zallen@cmmail.com
ICQ:101229409
 Long live of freedom!

RE: MTS - VB COM object Requires Transaction errors

Do you have the service pack for mts that supports transactions for db2? You can get it from one of microsoft's sites. It is also loaded with nt sp5. To find it go to msdn.microsoft.com and search for transactions and db2.

RE: MTS - VB COM object Requires Transaction errors

How to deploy components by writting code in vb?

RE: MTS - VB COM object Requires Transaction errors


 Hi

 Do you have your database set to support transactions ?

 Hugo

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