Going to guess this is not what you are looking for but we just put the query that sometimes fails inside a TRY/CATCH block so if it fails we catch that and email the dev team.

On 5/6/05, Moro, Giovanni <[EMAIL PROTECTED]> wrote:

Howdy Folks,

       I was wondering if anyone can point me to, or provide an example of
testing the DB connection.

       I often pull from two different databases and sometimes we run into
issues with the one we have no control over. I'm looking for a quick way to
test the connection so I can provide a more adequate error message to the
user.

       Thanks.

--Giovanni

----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email.

CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting ( www.cfxhosting.com).

CFCDev is supported by New Atlanta, makers of BlueDragon
http://www.newatlanta.com/products/bluedragon/index.cfm

An archive of the CFCDev list is available at www.mail-archive.com/[email protected]




--
Aaron Rouse
http://www.happyhacker.com/ ----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email.

CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com).

CFCDev is supported by New Atlanta, makers of BlueDragon
http://www.newatlanta.com/products/bluedragon/index.cfm

An archive of the CFCDev list is available at www.mail-archive.com/[email protected]

Reply via email to