Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re: PerlScript, ADODB, SQL Server updates not working

by olivierp (Hermit)
on Nov 17, 2004 at 12:47 UTC ( #408385=note: print w/ replies, xml ) Need Help??


in reply to PerlScript, ADODB, SQL Server updates not working

$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.
HTH
--
Olivier


Comment on Re: PerlScript, ADODB, SQL Server updates not working
Download Code
Replies are listed 'Best First'.
Re^2: PerlScript, ADODB, SQL Server updates not working
by pfaut (Priest) on Nov 17, 2004 at 22:45 UTC

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

    90% of every Perl application is already written.
    dragonchild

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://408385]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (17)
As of 2015-07-29 18:08 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (267 votes), past polls