Contact US

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.

Students Click Here

MTS , COM Component (Urgent)

MTS , COM Component (Urgent)

MTS , COM Component (Urgent)

I have COM components developed in VB. I am using SQL Server 7.0, MTS and ASP, HTML to design the web site.
I want a solution to the following situations.

1. Two different components totally independent of each other, called COM1 and COM2.
The Calling sequence is like this

COM1 calls COM2
If COM2 rollbacks the transaction (because any kind of error), it should roll back the transaction of COM1 also.

2. I want to use 2 databases Database1 and Database2. There are some components stored on Database1 and Database2. Can components on these 2 different databases call each other?

It's very URGENT !!!
Waiting for suggestions.


RE: MTS , COM Component (Urgent)

Regarding your question #1:

Set the class you're calling in your COM2 DLL so that it's MTSTransactionMode is "2 - Requires Transaction".  That way if COM1 starts a transaction then calls COM2, COM2 will make use of it.  If COM1 didn't have a transaction, then COM2 will create one.

If COM2 is making use of COM1's transaction, and calls the .rollback method, it will rollback COM1's transaction too.

Regarding question #2: I need more info.  What kind of components, how are they registered, how do you intend to call them?

Chip H.

RE: MTS , COM Component (Urgent)

Thanks for your suggestion.
i will try that and let you know.
Regarding the second question,
i have one database server and 2 databases on it.
one for Publishing System (publishing the content)
second for Cache Management System (for the web site user)

I have 2 components one for each system on 2 different databases. If Cache Management can't find the content in the cache, will call Publishing system to get the content. the publishing system will then get the content from the database and passed it to Cache Management, I want to call COM components to do this.
How can I accomplish this?

How it can be done in Wscript?
Where can I find sample examples?

Thanks once again

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