AutoIt tries to call COM VariantClear() on uninitialized memory

[coderpro@…]

A COM OLE query to an MS SQL Server database results in a crash in AutoIt's wrapper that calls oleaut32.dll VariantClear(). The attached file recreates the bug.

[coderpro@…]

Connect to an MS SQL Server to test COM

[mLipok]

this is the same problem like here:
​https://www.autoitscript.com/trac/autoit/ticket/2887

As you can see here:

Func _ExecStatements(Const $oConn, Const $sStatements, Const $bIgnoreInvalidObjRef = False)
    _WriteDiag("Info", "Executing: "&@CRLF&$sStatements)
    $COMstatusMessage = "attempting to execute query"

    If $bIgnoreInvalidObjRef Then
        $g_oErrObj = ObjEvent("AutoIt.Error", "_COMwarningHandlerWrapper")
    EndIf

    Local $oRecordSet = _SQLQuery($oConn, $sStatements)

    If $bIgnoreInvalidObjRef Then
        $g_oErrObj = ObjEvent("AutoIt.Error", "_COMerrorHandler")
    EndIf

    Return $oRecordSet
EndFunc

You are setting $g_oErrObj few times.
The workaround is to set:
$g_oErrObj = Null

Func _ExecStatements(Const $oConn, Const $sStatements, Const $bIgnoreInvalidObjRef = False)
    _WriteDiag("Info", "Executing: "&@CRLF&$sStatements)
    $COMstatusMessage = "attempting to execute query"

    If $bIgnoreInvalidObjRef Then
        $g_oErrObj = Null
		$g_oErrObj = ObjEvent("AutoIt.Error", "_COMwarningHandlerWrapper")
    EndIf

    Local $oRecordSet = _SQLQuery($oConn, $sStatements)

    If $bIgnoreInvalidObjRef Then
        $g_oErrObj = Null
        $g_oErrObj = ObjEvent("AutoIt.Error", "_COMerrorHandler")
    EndIf

    Return $oRecordSet
EndFunc

[J-Paul Mesnage]

no update so I close it