AutoIt is retrieving wrong values from Data Base (AS400 Data Base)

[mmahima]

When i try to execute the following statements in autoit, it is retrieving wrong values from database, could any one help.

$sqlCon = objCreate("ADODB.Connection")
$objRecordSet = ObjCreate("ADODB.RecordSet")
$sqlCon.Open("Provider='IBMDA400';Data Source = '10.0.1.25';User Id='USERNAME'; password='Password';")
$oRs = $sqlCon.Execute("select * FROM ccdata.rcmast where MSACT# = '8217'")
MSGBOX(0,"",$oRs.Fields("MSACT#").value)

Expected values is 8217, whereas it is retrieving 6213.

I tried using VBseditor for executing the above statement, vbseditor is retrieving correct from database whereas autoit is displaying wrong values.

[TicketCleanup]

Automatic ticket cleanup.

[Jpm]

Not sure some dev can help you as db2 is not a database use by default in our environment.
Can you reproduce with MSAccess database for instance?

[Valik]

Please read WikiStart on how to create a good ticket. You're making this overly difficult.