in reply to Re^2: FreeTDS (Linux) vs. SQLSRV32.dll (Windows) via ODBC
in thread FreeTDS (Linux) vs. SQLSRV32.dll (Windows) via ODBC

Aren't you supposed to call $test->finish(); before prepare()ing another query?

Replies are listed 'Best First'.
Re^4: FreeTDS (Linux) vs. SQLSRV32.dll (Windows) via ODBC
by pvbcharon (Beadle) on May 27, 2010 at 07:18 UTC

    According to http://search.cpan.org/~timb/DBI-1.611/DBI.pm#finish:

    When all the data has been fetched from a SELECT statement, the driver should automatically call finish for you. So you should not normally need to call it explicitly except when you know that you've not fetched all the data from a statement handle.

    I know that there isn't any more data. FreeTDS seems to disagree though...