RE: [dbi] Re: Attempt to initiate a new SQL Server operation with results pending.

2005-06-28 Thread Martin J. Evans
On 27-Jun-2005 Daniel Kasak wrote: Jeff Urlwin wrote: Please read DBD::ODBC pod. Specifically the section on the odbc_cursortype. Jeff I just added odbc_cursortype= DBI::SQL_CURSOR_DYNAMIC to our connection string, and that didn't help things at all. Martin J. Evans ( see other

Re: [dbi] Re: Attempt to initiate a new SQL Server operation with results pending.

2005-06-27 Thread Daniel Kasak
Martin J. Evans wrote: Just tried that. Doesn't seem to have any effect on my system. Here's the line I added right after create $dbh : $dbh-{odbc_SQL_ROWSET_SIZE} = 2; Didn't you say something about using FreeTDS? If so that hack might not work for FreeTDS. Against MS SQL Server ODBC

RE: [dbi] Re: Attempt to initiate a new SQL Server operation with results pending.

2005-06-23 Thread Martin J. Evans
Daniel, On 22-Jun-2005 Daniel Kasak wrote: Martin J. Evans wrote: As far as I am aware this is a limitation of the TDS protocol used and your example code will not work unless you force a server-side cursor (see DBD::ODBC pod and look for odbc_SQL_ROWSET_SIZE but I warn you that you really