SQLServer Query : how create exception if error ?

[Gigli]

Hi all,

I use this code to query my database.

$constrim="DRIVER={SQL Server};SERVER=localhost;DATABASE=MyBdd;;uid=sa;pwd=;"
$adCN = ObjCreate ("ADODB.Connection")
$adCN.Open ($constrim)
$sQuery="select * from personnel"
$result= $adCN.Execute($sQuery)
MsgBox(0,"",$result.Fields( "nom" ).Value )
$adCN.Close

It works fine, but if for example MsSqlServer service is down or the database is not attached, I've got this error

=> The requested action with this object has failed.:

$adCN.Open ($constrim)

$adCN.Open ($constrim)^ ERROR

How could I create a exception to contine to script in case of this error ?

Thanks you (sorry for my english )

[Juvigy]

Check this out: (from the help files)

$oMyError = ObjEvent("AutoIt.Error","MyErrFunc")

Func MyErrFunc()

Msgbox(0,"Test","Error !" & @CRLF & @CRLF & _

"err.description is: " & @TAB & $oMyError.description & @CRLF & _

"err.windescription:" & @TAB & $oMyError.windescription & @CRLF & _

"err.number is: " & @TAB & hex($oMyError.number,8) & @CRLF & _

"err.lastdllerror is: " & @TAB & $oMyError.lastdllerror & @CRLF & _

"err.scriptline is: " & @TAB & $oMyError.scriptline & @CRLF & _

"err.source is: " & @TAB & $oMyError.source & @CRLF & _

"err.helpfile is: " & @TAB & $oMyError.helpfile & @CRLF & _

"err.helpcontext is: " & @TAB & $oMyError.helpcontext _

)

Local $err = $oMyError.number

If $err = 0 Then $err = -1

$g_eventerror = $err ; to check for after this function returns

Endfunc

[water]

Or you could use the latest Beta version of AutoIt (3.3.9.2). This version doesn't crash anymore but sets @error.