Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
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

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?
[Corion]: Oh yes, Friday!
[Corion]: Last day at $work before 3 weeks of vacation (well, not that I'd be really travelling, but no-work-time ;) )
[robby_dobby]: marto: yeah, I'd eventually visit Glasgow some day - just to visit the home town of GHC :-)
[robby_dobby]: Corion: Oh, that's awesome! Your timing is perfect enough to see all hell break loose when you get back at work :P
[marto]: well, let me know in advance, I'll buy you a pint :)
[Corion]: robby_dobby: No, I'm returning in the second workweek of January. The main hectic parts are in the first days after the start of the new year
[robby_dobby]: marto: and, I'm not sure I'd be around here long enough for YAPC::EU
[marto]: Corion nice, what are you plans for Christmas?
[robby_dobby]: Corion: Nice, you just won't be around to deal with the mess - enjoy your vacation :-)
[robby_dobby]: marto: Sure, will do. Thanks!

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (9)
As of 2017-12-15 10:37 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    What programming language do you hate the most?




















    Results (431 votes). Check out past polls.

    Notices?