Capturing the error without halting script

[Jewtus]

I'm trying to do connection to a SQL db and I have it working:

$sqlCon = ObjCreate("ADODB.Connection")
$sqlCon.Open($connectionString)
If @error Then
    $CheckForLocal=MsgBox(4, "ERROR", "Failed to connect to the database")
    If $CheckForLocal='7' Then
        $trackLocal='Y'
    Else
        Exit
    EndIf
EndIf

When i force the connection to fail (put in an invalid password) I expected that it would pop up the error, but it actually halts my script and gives this on the console output:

  Quote

 

"Y:__SQLTransacts.au3" (13) : ==> The requested action with this object has failed.:

$sqlCon.Open($connectionstring)

$sqlCon^ ERROR

 

Any idea on what I'm doing wrong?

[water]

Which version of AutoIt do you run?

[Jewtus]

3.3.13.19

[water]

Your script should run fine with the latest stable.

The way COM errors are handled has been changed in the latest beta.

[JLogan3o13]

For the latest beta, try capturing the error yourself. Something like this:

Global $oErrorHandler = ObjEvent("AutoIt.Error", "_ErrFunc")

$sqlCon = ObjCreate("ADODB.Connection")
$sqlCon.Open($connectionString)


Func _ErrFunc()
    $CheckForLocal=MsgBox(4, "ERROR", "Failed to connect to the database")
        If $CheckForLocal='7' Then
            $trackLocal='Y'
        Else
            Exit
        EndIf
EndFunc

[Jewtus]

That did it. Thanks!

[mLipok]

  On 12/16/2014 at 1:55 PM, water said:

The way COM errors are handled has been changed in the latest beta.

 

Where I can find any descriptions for this change ?