Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

asp, MTS, and credit card transactions

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Joined
Jan 1, 1970
Messages
0
I know virtually nothing about MTS.

I have an asp page which uses a third party credit-card processing component (Verisign's PaymentFlowPro). I have the page working OK and it approves or denies credit-card transactions appropriately which is followed by a some database actions on my server.

Suppose that the transaction is approved but an error then occurs in my asp page (or the connection is lost or whatever). I think I understand that if I make this page transactional, MTS will rollback any local database changes. However, if the bank transaction was successful on the remote server and funds were transferred, but then an error occurs in my asp page, how will MTS also rollback the remote changes? There would be no record in my database of an order but the user will get a credit-card bill...

Does this question make sense? Maybe I don't understand what MTS is doing. Can anyone explain this to me?



 
Sort by date Sort by votes
If the DBMS supports XA/OLE transaction protocol,then any error will cause the transaction roll back normally!

But i donnot know if the credit card component will compatible with MTS!


Regards!
 
Upvote 0 Downvote
Thanks.

I'll ask Versign about the component.

any other comments appreciated.
 
Upvote 0 Downvote
We've written our own credit/debit card payment system using ASP & MTS.

We use software from Retail Logic for the bank connectivity.
 
Upvote 0 Downvote
In your custom system, how does MTS rollback the remote transaction? For example if the remote back transaction involves moving funds and a local error of somekind occurs does the remote transaction somehow get undone? Can you describe a little bit how you used MTS for this task?
 
Upvote 0 Downvote
The MSDTC (Distributed Transaction Coordinator) takes care of the two-phase commit work done here. It's all documented in MSDN, and if you don't have the CDs, visit msdn.microsoft.com and search on MSDTC, etc...

Tom
 
Upvote 0 Downvote
We cannot use MS-DTC to rollback the transaction as our links to the bank do not support it.

If the communcation fails then we simply set the status of a SQL Server record to Error.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

densorz
  • Locked
  • Question Question
Cannot update database with MTS/Oracle8i??
Replies
0
Views
660
densorz
densorz
revilord
  • Locked
  • Question Question
What is the difference between MTS and COM+?
Replies
0
Views
625
revilord
revilord
jedel
  • Locked
  • Question Question
Finding MTS
Replies
0
Views
386
jedel
jedel
Skittle
  • Locked
  • Question Question
MTS Installation
Replies
2
Views
477
Skittle
Skittle
akneeta01
  • Locked
  • Question Question
Equivalent of MTS Remote components in COM+
Replies
0
Views
617
akneeta01
akneeta01

Part and Inventory Search

Sponsor

Back
Top