Gigli Posted March 13, 2012 Share Posted March 13, 2012 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 ) Link to comment Share on other sites More sharing options...
Juvigy Posted March 13, 2012 Share Posted March 13, 2012 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 Link to comment Share on other sites More sharing options...
water Posted March 13, 2012 Share Posted March 13, 2012 Or you could use the latest Beta version of AutoIt (3.3.9.2). This version doesn't crash anymore but sets @error. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now