Variable must be of type "Object"

[GAM]

Hi All

Am trying to write a script that retreives the values form the database but it gives me an error "Variable must be of type "Object". Can someone help me please.

The code is as follows...

----------------------------------------------------------------------------------

$constrim="DRIVER={SQL Server};SERVER=WIN-1VETHTGJK1NEPOSERVER;DATABASE=AntiVirus;uid=Administrator;pwd=Welcome2mcafee;"

$adCN = ObjCreate ("ADODB.Connection") ; <== Create SQL connection

$adCN.Open ($constrim) ; <== Connect with required credentials

MsgBox(0,"",$constrim )

if @error Then

MsgBox(0, "ERROR", "Failed to connect to the database")

Exit

Else

MsgBox(0, "Success!", "Connection to database successful!")

EndIf

$sQuery = ObjGet("select * from Sample1 where USerID = 'ABC'")

$result = $adCN.Execute($sQuery)

MsgBox(0, "", $result.Fields( "UserID" ).Value)

$adCN.Close

Edited September 15, 2014 by GAM

[GAM]

The complete error that gives is... "C:Program Files (x86)AutoIt3SciTE..autoit3.exe" /ErrorStdOut "C:UsersAdministratorDesktopppmstemp.au3" "C:UsersAdministratorDesktopppmstemp.au3" (18) : ==> Variable must be of type "Object".: MsgBox(0, "", $result.Fields( "UserID" ).Value) MsgBox(0, "", $result^ ERROR

[Luigi]

Hi GAM, the driver ODBC is installed? For me, if I don't install ODBC to Postgress or MySQL, I receive the same error message. I never use MSSQL (I presumed).
Or your ODBC is not properly config.