How to rollback in vbs

[EdRev]

I have an sql tht I execute in my vbs.

strConn = stringDSN

strsql3 = "update tbl set col = null"

Set objConnection = CreateObject("ADODB.Connection&quot
objConnection.connectionstring = strConn
objConnection.Open

Set Comm = CreateObject("ADODB.Command&quot
set Comm.ActiveConnection = objConnection
Comm.commandtype = 1

Comm.commandtext = strsql3
Comm.execute

How can I roll it back if there is any error?

Any help will be greatly appreciated.

 

[jemminger]

maybe this will help:

http://www.eggheadcafe.com/PrintSearchContent.asp?LINKID=142

=========================================================
if (!succeed) try();
-jeff