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

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 Ser

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 >>r