Vbs Error Trapping

[Guest Guest_vinesh]

hi there, does anyone have an example to trap a database connection errors on a vbs module so that i can send an email or something to inform me that the database is down.

[vinesh]

sorry it wasn't a vbs module, its a database connection module, how do you trap errors on the database module, e.g. if a database server goes down, how do i trap those errors ?

 

[checkCLI]

Type=Database Query

DispSize=69

Txt=Check CLI

DbDatabase=ClientDatabase

DbUser=

DbConnectString=odbc;uid=UserName;pwd=Password

DbSql=SELECT TOP 1 * FROM tblClients Where ClientID = '1234567890'

on {success} goto [setCount1]

on {fail} goto [NonRegisteredUser]

on {timeout 10} goto [DatabaseTimeout]

[SupportTeam]

If a database goes down then you would usually get the query timing out...

I'd suggest using the timeout path as you are already.

 

If you find that you are having an error returned instead then please post a copy of VoiceGuide's Debug Printout which captures the problem.

 

(When running the script click on VoiceGuide's View menu and select 'Event Trace Log' option - any log information will then appear in this window. You must open the trace window before making the call.

You can enable the automatic saving of the logs to files in \log\ directory as well.)