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!

*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.

Jobs

Cannot update database with MTS/Oracle8i??

Cannot update database with MTS/Oracle8i??

(OP)
I've developed a 3-tier webservice (ASP/COM+/ORACLE) that after some troubles now works fine when firing select statements on the database. However when trying to fire an insert or update statement I get errors. I think it's because of the value assigned to the property MTSTransactionMode in Visual Basic(version 6). What should this value be?

In COM+ I declared for every thread several classes.
MGR class: entrance
DAN class: executing select statements (This works fine!)
DAT class: executing insert and update statements

The DAN-classes have value 3(=UsesTransaction) and the DAT-and MGR-classes have value 2(=RequiresTransaction).


Here are the errors:

If I change MTSTransactionMode for DAT and MGR to 0, 1 or 2:

CODE


Error 00013 : 06-03-2006 16:18:07
  - Description: addRequest(DAT):   - 'Type mismatch'
  - Line Number: 5
 
If I change MTSTransactionMode for DAT and MGR to 3:

CODE


Error -2147168246 : 06-03-2006 16:22:28
  - Description: GetConnection error: 'Provider=OraOLEDB.Oracle;Data Source=demo8;User Id=arnhem90;Password=arnhem90' - 'De nieuwe transactie kan niet worden opgenomen in de lijst voor de opgegeven transactieco√∂rdinator.'
  - Line Number: 50
 
Error 03709 : 06-03-2006 16:22:28
  - Description: getTabValue: 'De verbinding kan niet worden gebruikt om deze bewerking uit te voeren. De verbinding is gesloten of deze is ongeldig in deze context.'
  - Line Number: 10
 
Error 00091 : 06-03-2006 16:22:28
  - Description: addRequest(MGR): 'Object variable or With block variable not set'
  - Line Number: 50

Thanks for the help provided!

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!

Resources

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