Re: PerlScript, ADODB, SQL Server updates not working

[olivierp]

$rs->Open($cmd,undef,adOpenStatic,adLockPessimistic);
        if ($rs->{EOF}) {
            # ....
        } else {
         #...
                         $rs->Update;
         #...
        }

I'm wondering if using a cursor that is defined as read only and scrollable, and then trying to update it, could be causing you problems.

[pfaut]

Those are the same parameters we use in the VBScript code to get an updateable recordset. That code works fine.