Who's gonna step up?

Results 1 to 2 of 2

Thread: Who's gonna step up?

  1. #1
    Join Date
    Dec 1969

    Default Who's gonna step up?

    Anyone know if this is possible? Recently I&#039ve been having some host problems, which have ended up locking users out of the databases. What was happening was too many DB connections were open and the server wouldn&#039t serve up any connections, bringing things effectively to a halt. I was wondering if it&#039s possible to test to see if a DB connection is available, if it is, connect to it. If not, then display a message stating that the DB wasn&#039t available at the moment, but load the rest of the page.<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Who's gonna step up?

    Testing if a db conn is available<BR>On Error Resume Next<BR>set dbconn=Server.CreateObject("ADODB.Connection")<BR> dbconn. open &#039 put your connect params here<BR>if Err.Number&#060;&#062;0 then <BR> response.write "Database is unavailable<BR>end if<BR><BR>sound good?<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts