Handling ADO Error

[michaelslamet]

In code below, I try to capture an error that cause by .MoveNext

It doesn't work because maybe .MoveNext doesn't generate @error.

$SQLCode = "SELECT blabla;"

$TableContents = _Query ($SQLInstance_Local, $SQLCode)
 
If Not @error Then
    With $TableContents
        While Not .EOF
            ;doing something here
            .MoveNext
            If @error Then
                Msgbox(0,"Error","Server unreachable!")
                Exit
            EndIf
        WEnd
    EndWith
EndIf

How to capture the error WITHOUT using ObjEvent (eg: $objErr = ObjEvent("AutoIt.Error","MyErrFunc")) ?

Edit: the reason I dont want to use $objErr = ObjEvent("AutoIt.Error","MyErrFunc") is because IE.au3 generate a lot of errors

when the error handler is active so the script is pushed to exit.

How to turn off the error handler just for IE.au3?

Edited January 27, 2014 by michaelslamet

[water]

Which version of AutoIt do you run?

[michaelslamet]

Which version of AutoIt do you run?

 

Hi Water,

I'm running 3.8.8.1 on WinXP and Win7

[water]

With AutoIt > 3.3.8.1 the script no longer crashes when a COM error occurres. You simply check @error. So a COM error handler is only needed if you want to retrieve more detailed error information (true for IE UDF and ADO ...).

[michaelslamet]

With AutoIt > 3.3.8.1 the script no longer crashes when a COM error occurres. You simply check @error. So a COM error handler is only needed if you want to retrieve more detailed error information (true for IE UDF and ADO ...).

 

I'm not sure if I'm understand you. In this scenario, how to catch the error when --let say-- query all of the records and suddently the server is unreachable?

$SQLCode = "SELECT blabla;"

$TableContents = _Query ($SQLInstance_Local, $SQLCode)
 
If Not @error Then
    With $TableContents
        While Not .EOF
            ;doing something here
            .MoveNext
            If @error Then
                Msgbox(0,"Error","Server unreachable!")
                Exit
            EndIf
        WEnd
    EndWith
EndIf

 

Register an error handler seems doesn't solve it, the error handler doesn't display anything when the connection is broken.

Checking the @error seems not a solution too, because .movenext doesn't return any @error

[water]

How do you now notice that an error occurred? Script crash, error message, @error is set ...?

[michaelslamet]

Water,

Thanks for your help

The error handler works great, seems just because I place it on the wrong place

[water]