|
 |  |  |  |  |  |  |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
 |
| |
11-20-2008
| #1 (permalink) |
| | Re: Error handling SQl database Ammy wrote: Quote: > Can anybody help me wih a script. > > I have a script that queries data from a sql database. > If the database is not online i want a error handling in the script, > but i do not know. > > > > Const adOpenStatic = 3 > Const adLockOptimistic = 3 > > Set objConnection = CreateObject("ADODB.Connection") > Set objRecordSet = CreateObject("ADODB.Recordset") > objConnection.CommandTimeout = 180 Quote: > objConnection.Open _ > "Provider=SQLOLEDB;Data Source=server001 _ > "Trusted_Connection=Yes;Initial Catalog=testdatabase > > > If Err.Number <> 0 Then > MsgBox Err.Number > Err.Clear > End If > > Ammy HTH, Bob Barrows |
My System Specs |
|
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| Re: error handling | VB Script | |||
| WMI Error Handling | PowerShell | |||
| error handling | PowerShell | |||
| Crash Course in Error Handling? | PowerShell | |||
| Error Handling | PowerShell | |||
