Hi,
How to use begin trans and commit trans when we execute a strored procedure using ado command.
I have a stroed procedure to inser values... if i use...sql query to insert its working..
if i use command.. it gives as error.

con.open
con.begintrans
con.execte(--sqlquery--)
con.committrans

same thing in command

con.open
' assigned the storedprocedure paramertes and type.
'
con.begintrans
cmdCommand.activeconnection = con ' gives an error say connection busy...
cmdcommand.execute
con.comminttrans

solution please
-Arjun