Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ADO Open connections 1

Status
Not open for further replies.
beruken

beruken

Programmer
Mar 12, 2002
22
US
Can anyone tell me the implications or Pros/Cons on keeping a DB connection open via the Global.asa? This is on an Intranet.
 
Sort by date Sort by votes
It is a bad idea to cache connections in an application object. If one connection is cached in the application object and multiple pages access the connection, they will all contend for use of the connection.

Create and destroy the connection on every page that uses the connection.

gordon
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dwg23
  • Locked
  • Question
ADODB.Recordset error '800a0cc1' Item cannot be found in the collection corresponding to the reques
Replies
3
Views
172
gmmastros
gmmastros
dekesc
  • Locked
  • Question
Complex filtering of an ADO Recordset
Replies
5
Views
98
wbodger
wbodger
rahlquist
  • Locked
  • Question
Converting data connections to use parameters
Replies
3
Views
77
rahlquist
rahlquist
dekesc
  • Locked
  • Question
porblem with quotes in building an ADO SELECT with multiple AND's
Replies
7
Views
88
dekesc
dekesc
joneebravo
  • Locked
  • Helpful tip
Opening a .PDF using Step7 TIA Portal VBscript
Replies
0
Views
113
joneebravo
joneebravo

Part and Inventory Search

Sponsor

Back
Top