Re: connection pooling and commits

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 02/03/04 

Date: Tue, 3 Feb 2004 11:35:02 -0800

Consider that each operation has an implied transaction that the server
manages. It's not necessary to manage the transactions yourself when a
single table operation is being done (that might be what you're doing).
Frankly, I don't recommend client-side transactions at all--I recommend that
folks use stored procedures that handle any transactions when changing more
than one base table. 

-- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Darin" <anonymous@discussions.microsoft.com> wrote in message
news:98C2F7EE-A9BF-4F43-B54C-5C69D4D06B4E@microsoft.com...
> Thanks for the reply Bill.
>
> When I'm inserting/updating multiple tables I do the
trans.begintransaction and trans.commit and then close the connection.
>
> My question is when I'm inserting/updating a single table I call
ExecuteNonQuery and call the Close() method of the connection object without
any commits in my code.  Now that the connection went back to the pool is a
transaction is still pending since I didn't do any manual commits or does
the connection know I'm done and commits since I called Close()?

Relevant Pages

  • Re: Working Transactions somehow started not to work
    ... For the simple reason: transactions and locking involve ... Client-based cursors create their own ... the server-based cursors, hence from locking, hence from transactions. ... SL> Instead of using one of the connection created by Access, ...
    (microsoft.public.access.adp.sqlserver)
  • RE: [Full-Disclosure] RE: MS SQL WORM IS DESTROYING INTERNET BLOCK PORT 1434!
    ... sites is not that transactions are going over the Internet through vpn ... connection for that matter when you can get thousands from a SQL database?) ... Subject: [Full-Disclosure] RE: MS SQL WORM IS DESTROYING INTERNET ...
    (Full-Disclosure)
  • Re: Working Transactions somehow started not to work
    ... are not associated necessarily with server-based cursors. ... For the simple reason: transactions and locking involve ... SL> Instead of using one of the connection created by Access, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Working Transactions somehow started not to work
    ... For the simple reason: transactions and locking involve ... the server-based cursors, hence from locking, hence from transactions. ... make begintrans etc. fully working in ADP, but then it was stopped in the ... SL> Instead of using one of the connection created by Access, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Working Transactions somehow started not to work
    ... Even if you have a single form without subforms and without comboboxes (another case of separate connection), ... MC>> transactions. ... MC>> from the server-based cursors, hence from locking, hence from ... MC>> In all new programming environments, Microsoft is actually pushing ...
    (microsoft.public.access.adp.sqlserver)