In my VB program I use the connection object (abc)
to begin a transaction.
abc.BeginTrans
I then, in my VB App, using ADO, execute multiple stored procedures
inserting records into temp tables ##Meetings,
reading them, and then finnaly executing (from my VB app
using ADO) as stored procedure that inserts records
into a non-temp table.
I then have a abc.CommitTrans
What if my VB program crashes before the
committrans is executed, I assume that the transaction
is rolled back, even though no explicit rollback
is issued, because my VB program has crashed.
Thank You for your help,
Laurence Nuttall
Programmer Analyst III
UCLA - Division of Continuing Education
.
Executing stored procedures as CommandType=Text ... I've got an urgent problem - I'm converting a legacy VB app to .NET. ... 'p3'" that execute on a VB 6 application and ADO. ... I receive the SQL requests in the string format with all the parameters ... This worked fine under ADO.... (microsoft.public.dotnet.framework.adonet)
get record count from stored procedure without passing DATA back? ... Is it possible in ADO to execute a stored procedure, ... My client has some stored procedures which if executed with certain ... I cannot change the stored procedures, only the ADO code.... (microsoft.public.dotnet.framework.adonet)
Re: Problem with Deletes in code ... DoCmd.RunSQL to execute the delete query.... 'All records in rsSourceProjects will be for the same project, ... problem with ADO interacting with the tables, ... (microsoft.public.access.modulesdaovba)
Requested Registry Access is Not Allowed ... We have several applications that will be executing on multiple machines. ... will execute the apps. ... There are Permission Sets within the framework configuration tool, ... The app fails on the WriteEntry and the exception that is thrown is ... (microsoft.public.dotnet.framework)
RE: Requested Registry Access is Not Allowed ... > We have several applications that will be executing on multiple machines. ... > will execute the apps. ... > There are Permission Sets within the framework configuration tool, ... > machine that the app will run. ... (microsoft.public.dotnet.framework)
