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 >>will need to close everything i.e. force SQLFreeStmt(SQL_CLOSE) or you will >>get >>hangs). >> >> > I see. Sounds good. > >>BTW, the example in the pod should be $dbh->{odbc_SQL_ROWSET_SIZE} = 2 not >>$dbh->{SQL_ROWSET_SIZE} = 2. >> >> >> > 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 driver it works - I tried it with your example. >>I would seriously suggest you try and avoid multiple active statements - >>there >>is nearly always a SQL or some other way. >> >> > Perhaps. To be honest I'm not that concerned. If it was DBD::mysql I'd > be mortified, but I don't have too much to do with SQL server, so I'll > just create lots of $dbh things and ->finish all the statements and hope > that things hold together while I'm sitting around twiddling my thumbs > waiting for MySQL-5.0.x to stabalise ( stored procedures & views ). > > Thanks for your help. Martin -- Martin J. Evans Easysoft Ltd, UK Development