Home | Advertising Info6 USERS CURRENTLY ONLINE   
PowerASP
   Site Search Contact Us Thursday, May 02, 2024  

  Active InfoActive Info  Display List of Info MembersMemberlist  Search The InfoSearch  HelpHelp
  RegisterRegister  LoginLogin
Classic ASP - Database Issues
 PowerASP Code Help Area : Classic ASP - Database Issues
Subject Info: connection pooling and transactions A d d - P o s tAdd P o s t
Author
Message << Prev Info | Next Info >>
tdrumm
Newbie
Newbie


Joined: April/26/2005
Online Status: Offline
Info: 2
Added: April/26/2005 at 6:24am | IP Logged Quote tdrumm

IIS uses connection pooling (as far as I've been told) to optimize database access.

On our site, we've experimented with transactions (using Connection.BeginTrans) for some time, but one major issue is holding us back.

In case an error occurs on the page and we do not rollback or commit the transaction, will this connection still be in transaction mode when returned to the connection pool? Will this connection be given to another process from the pool when requested?

Thanks in advance!
Back to Top View tdrumm's Profile Search for other info by tdrumm
 
cwilliams
Admin Group
Admin Group
Avatar

Joined: April/26/2004
Location: United States
Online Status: Offline
Info: 137
Added: April/26/2005 at 12:14pm | IP Logged Quote cwilliams
Please leave no assumptions for people.
One would assume you are talking about using Microsoft SQL server with the transactions and all but please put that information as well as other details out on the table. Version of MSSQL, Server OS ?? etc etc

Edited by cwilliams on April/26/2005 at 12:16pm

__________________


Chris Williams
http://www.PowerASP.com
Back to Top View cwilliams's Profile Search for other info by cwilliams
 
tdrumm
Newbie
Newbie


Joined: April/26/2005
Online Status: Offline
Info: 2
Added: April/26/2005 at 4:07pm | IP Logged Quote tdrumm

Sorry for the missing information.

It's an IIS 5.0 on a Windows 2000 Server, running on an SQL Server 2000 SP3A.

The connections are opened using a cn.open statement, and it's a DNS-less connection string.

I hope this helps.
Back to Top View tdrumm's Profile Search for other info by tdrumm
 

If you wish to make a comment to this info you must first login
If you are not already registered you must first register

  A d d - P o s tAdd P o s t
Printable version Printable version

Info Jump
You cannot add new info in this area
You cannot add to info in this area
You cannot delete your info in this area
You cannot edit your info in this area
You cannot create polls in this area
You cannot vote in polls in this area

   Active Server Pages Rule The World
 Contact Us  
All artwork, design & content contained in this site are Copyright © 1998 - 2024 PowerASP.com and Christopher J. Williams
Banner ads ,other site logos, etc are copyright of their respective companies.
 STATS Unless otherwise noted - All Rights Reserved.

Active Server Pages ASP control controls class classes module script Scripts applet CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspprotect.com, www.cjwsoft.com,www.aspclassifieds.com,www.aspphotogallery.com