vb 6.0 Transaction

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: jose.mendez22@xxxxxxxxx
Date: 11 Oct 2005 10:02:36 -0700

Q: in my vb 6 code I begin a transaction. I call several MS SQL 7.0
stored procedures that contain individual commit trans statements. If
an error takes place in my code and I call the rollback trans. will the
data in the db that committed with the individual trans also be rolled
back (note: within one individual trans session)?

Q: Also in my code I begin a transaction session and call two stored
procedures, in the following order (1) sproc contains no transaction
wrapper in sproc (2) sproc contains transaction wrapper in sproc.
during this process the tables used in the 1st sproc are locked however
as soon as the second sproc executes it unlocks all the tables used in
the 1st sproc and does not save the data, however data executed in 2nd
sproc works correctly. Am I missing something?

Thanks in advance for your input.

.

Prev by Date: Re: An ActiveX control on this page might be unsafe to interact with o
Next by Date: Calling a VB DLL from ASP
Previous by thread: Re: An ActiveX control on this page might be unsafe to interact with o
Next by thread: Calling a VB DLL from ASP
Index(es):
- Date
- Thread

Relevant Pages

Re: Backups and Transaction Log file size
... It sounds like a classic case of a long running open transaction. ... Find the client and either commit or roll it back. ... If you know it is a garbage connection you can kill the SPID and it will roll back any changes that the SPID may have open and allow you to backup and truncate properly. ... Once the committed trans have been ...
(microsoft.public.sqlserver.setup)
creating jobs programmatically causes deadlocks
... I'm using the transactional sproc below to create jobs in an automated ... On another server dropping just 10 of the trigger files causes ... The transaction is necessary since the ... DECLARE @ReturnCode INT ...
(microsoft.public.sqlserver.server)
Re: SqlTransaction, t-sql transactions, and distributed transactions
... It's my understanding that you can say nest BEGIN TRANSACTION ... Within the context of a single sproc, ... transaction around the posting but it won't actually queue the ... but this is a classic ADO newsgroup. ...
(microsoft.public.data.ado)
Re: Typed Dataset and transactions in ADO.NET 2.0
... Maybe this style...just across a couple of commands ... SqlTransaction trans; ... bReturnLog = ErrorLog.ErrorRoutine; ... I have a general question about typed datased and transaction. ...
(microsoft.public.dotnet.framework.adonet)
Re: Enclosing Sproc error inside xp_sendmail
... >> I'm trying to create a sproc that will run inside a job. ... >> SELECT EventID, EventType, UserName, Terminal, EventDate, Version ... >> COMMIT TRANSACTION ...
(microsoft.public.sqlserver.programming)