Error when I try to commit my transaction
Posted on 2001-06-12
I have a series of sqlqueries I wish to use all or none...problem is I keep getting this error message when I try to commit the transaction...
"Cannot create new connection because in manual or distributed transaction mode"
my connection object is declared in a module and then used throughout my code..
BTW:when I ask the conn for its mode it reports 0...
On Error GoTo rollback
Set resultset1 = conn.Execute(sqlstr_test)
On Error Resume Next