tonytpark
asked on
Transaction in ASP?
If I am tring to do the following Transaction,it's giving me error....
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Can not start transaction while in firehose mode.
conn.BeginTrans
conn.execute "Update aid set aid=" &myaid
conn.execute useradsql
conn.execute descsql
conn.execute myultimatesql
conn.CommitTrans
Please give me sugestion on how to do batch transaction in ASP.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Can not start transaction while in firehose mode.
conn.BeginTrans
conn.execute "Update aid set aid=" &myaid
conn.execute useradsql
conn.execute descsql
conn.execute myultimatesql
conn.CommitTrans
Please give me sugestion on how to do batch transaction in ASP.
ASKER
Edited text of question.
Have you thought of writing a stored procedure and then passing useradsql, descsql, myultimatesql as parameters ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
GREETING!
This question was awarded, but never cleared due to the JSP-500 errors of that time. It was "stuck" against userID -1 versus the intended expert whom you awarded. This corrects the problem and the expert will now receive these points; points verified.
Please click on your Member Profile and select "View Question History" to navigate through any open or locked questions you may have to update and finalize them. If you are an EE Pro user, you can also choose Power Search to find all your open questions.
This is the Community Support link, if help is needed, along with the link to All Topics which reflects many TAs recently added. You'll also find a link there for Experts who wish to participate in the cleanup effort of old and abandoned questions.
https://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
https://www.experts-exchange.com/jsp/zonesAll.jsp
Thank you,
Moondancer
Moderator @ Experts Exchange
This question was awarded, but never cleared due to the JSP-500 errors of that time. It was "stuck" against userID -1 versus the intended expert whom you awarded. This corrects the problem and the expert will now receive these points; points verified.
Please click on your Member Profile and select "View Question History" to navigate through any open or locked questions you may have to update and finalize them. If you are an EE Pro user, you can also choose Power Search to find all your open questions.
This is the Community Support link, if help is needed, along with the link to All Topics which reflects many TAs recently added. You'll also find a link there for Experts who wish to participate in the cleanup effort of old and abandoned questions.
https://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
https://www.experts-exchange.com/jsp/zonesAll.jsp
Thank you,
Moondancer
Moderator @ Experts Exchange
ASKER