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 post on topic ) says that this won't work if > I'm using FreeTDS.
I didn't quite say that. I said "Didn't you say something about using FreeTDS? If so that hack might not work for FreeTDS. Against MS SQL Server ODBC driver it works - I tried it with your example.". I've not got FreeTDS to try it. > Not to worry. $sth->finish everywhere is what's gotten us this far, and > SQL Server is only used for legacy stuff anyway. To be honest I'm > surprised that it ( connecting to SQL Server from Linux ) works at all. > > Thanks for the help everyone. What I know for definite works direct to the MS SQL Server ODBC Driver and through our ODBC-ODBC Bridge from UNIX to MS SQL Server ODBC Driver is both the change for the cursor type and the change to use odbc_SQL_ROWSET_SIZE. However, you must be very careful to make sure the cursor is closed properly when using these methods or the MS SQL Server driver can hang on a later statement. For portability, I never use multiple active statements. I always reorganise my SQL or if that can't be done open another connection. Martin -- Martin J. Evans Easysoft Ltd, UK Development