Microsoft Transaction Server 1

[Mighty]

Hi Folks,

I have an ASP Intranet application that currently runs on IIS 6.0 on Windows Server 2003. I will shortly be developing a new utility on the Intranet site and would like to be able to roll back all database updates if any individual update fails. From looking at old ASP notes this appears to be possible if I write a component to do the database updates and use Microsoft Transaction Server. To date, i have done neither. From looking on the Microsoft site, all information on MTS seems to relate to Windows NT 4.0. Does MTS not exist for Windows Server 2003 or has it been replaced with something else.

If I was to write this particular utility in ASP.NET is there a better way to do it in .NET? Any advice would be appreciated.

Mighty

 

[onpnt]

why not use COMMIT and ROLLBACK in you SQL? Seems like a long winded solution to go with a utility when SQL can error handle a failure and ROLLBACK the TRANS if so.

Maybe I'm not understanding the entire needs though.

basic rollback tutorial



General FAQ faq333-2924
5 steps to asking a question faq333-3811

 

[Mighty]

And there was me thinking that I knew a little SQL. I didn't realise that it was that simple. I presume that this is a universal thing and will work on all databases - not just SQL Server.

We are using Pervasive databases here.

Mighty

 

[onpnt]

Looks like Pervasive 9.1 does

Pervasive.SQL 9.1

Thanks for the *



General FAQ faq333-2924
5 steps to asking a question faq333-3811

 

[Sheco]

PS: If you need MTS for other projects then be aware that starting with Windows 2000 it was renamed ... Look for COM+ or Component Services under Control Panel -> Administrative Tools.