Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation

RE: DBD::ODBC problem.

by barndoor (Pilgrim)
on Aug 09, 2000 at 13:27 UTC ( #26994=note: print w/replies, xml ) Need Help??

in reply to DBD::ODBC problem.

A known issue that affected SQLServer 6.5 (and I'm guessing 7.0) is that if you open a cursor using a prepare/execute and start reading through it, if you perform a commit or rollback and then try to continue reading from the cursor (perform another fetchrow) you will get the error you describe. I.E. The cursor is closed by the commit/rollback.
I don't know if this is your problem but it's worth checking.

Replies are listed 'Best First'.
RE: RE: DBD::ODBC problem.
by Corion (Pope) on Aug 09, 2000 at 13:36 UTC

    I have no MS SQL Server 7.0 available to test this, but the MS SQL Server 7.0 is a complete rewrite, as Microsoft does not use the Sybase codebase anymore. So I'd assume a lot of differences between 6.5 and 7.0.

      There is a service patch available that allows backwards compatibility (read allows old Sybase connection libs to be used). It's been mentioned here before, I believe, and it's recommended by Michael Peppler in order to work with DBD::Sybase. I'm waiting for his reply on the dbi-users mailing list about my other problems with that. Looks like I found a project to join. :) ALL HAIL BRAK!!!

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (5)
As of 2020-03-30 17:37 GMT
Find Nodes?
    Voting Booth?
    To "Disagree to disagree" means to:

    Results (175 votes). Check out past polls.