ADO/ASP Transaction

[Luciano]

Hi all,

I need run a code like this:

#
SET dbConn = SERVER.CREATEOBJECT("ADODB.Connection")
dbConn.OPEN Session("DSN_String")

dbConn.BeginTrans

SQL1="DELETE ...."
dbConn.EXECUTE(SQL)

SQL2="INSERT .... (error: Cannot create new connection because in manual
transaction mode)
dbConn.Execute(SQL2)

dbConn.CommitTrans
#

But an error is raised.
How can I execute two or more commands in the same transaction ?

Thanks,

LFDJ
LF...@SERPRO.GOV.BR

[da_...@my-deja.com]

Hi, Try adding a line like this

dbConn.CursorLocation = adUseClient ' Lookup the constant for
' adUseClient for ASP pages
Before the open attempt, it works for me..

Kevin

In article <#TpOZQJy#GA.202@cppssbbsa05>,

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.