I have just uploaded the official 1.24 release of DBD::ODBC to CPAN. Many thanks to everyone who has helped with this whether it was patches or testing. Here are the changes since 1.23:
=head2 Changes in DBD::ODBC 1.24 May 14, 2010 Minor change in Makefile.PL to only use NO_META if ExtUtils::MakeMaker is at least at version 6.10. Reported by Chunmei Wu. Minor change to test rt_50852 which had wrong skip count. =head2 Changes in DBD::ODBC 1.23_5 May 6, 2010 Added advice from Jan Dubois (ActiveState) on building DBD::ODBC for ActivePerl (see README.windows). rt56692. Fix spelling mistake in DBD::ODBC pod - thanks to Ansgar Burchardt. Added a 7th way to help documentation - become a tester. Hopefully fixed problems building on windows 32 bit platforms that have old sql header files not mentioning SQLLEN/SQLULEN. =head2 Changes in DBD::ODBC 1.23_4 April 13, 2010 Added more FAQs. Small optimization to remove calls to SQLError when tracing is not turned on. This was a bug. We only need to call SQLError when SQLExecute succeeds if there is an error handler or if tracing is enabled. The test was for tracing disabled! Large experimental change primarily affecting MS SQL Server users but it does impact on other drivers too. Firstly, for MS SQL Server users we no longer SQLFreeStmt(SQL_RESET_PARAMS) and rebind bound parameters as it is causing the MS SQL Server ODBC driver to re-prepare the SQL. Secondly (for all drivers) we no longer call SQLBindParameter again IF all the arguments to it are the same as the previous call. If you find something not working you better let me know as this is such a speed up I'm going to go with this unless anyone complains. Minor change to avoid a double call to SQLGetInfo for SQL_DBMS_NAME immediately after connection. Small change for rt 55736 (reported by Matthew Kidd) to not assume a parameter is varXXX(max) if SQLDescribeParam failed in the Microsoft Native Client driver. =head2 Changes in DBD::ODBC 1.23_3 March 24, 2010 Minor changes to Makefile.PL and dbdimp.c to remove some compiler warnings. Fix some calls to SQLMoreResults which were not passing informational messages on to DBI's set_err. As you could not see all the informational messages from procedures, only the first. Fix minor issue in 02simple test which printed the Perl subversion before the version. Changes to 20SqlServer.t to fix a few typos and make table names consistent wrt to case - (as someone had turned on case-sensitivity in SQL Server) Similar changes in rt_38977.t and rt_50852.t =head2 Changes in DBD::ODBC 1.23_2 January 26, 2010 Fixed bug in Makefile.PL which could fail to find unixODBC/iODBC header files but not report it as a problem. Thanks to Thomas J. Dillman and his smoker for finding this. Fixed some compiler warnings in dbdimp.c output by latest gcc wrt to format specifiers in calls to PerlIO_printf. Added the odbc_force_bind_type attribute to help sort out problems with ODBC Drivers which support SQLDescribeParam but describe the parameters incorrectly (see rt 50852). Test case also added as rt_50852.t. =head2 Changes in DBD::ODBC 1.23_1 October 21, 2009 makefile.PL changes: some formatting changes to output warn if unixodbc headers are not found that the unixodbc-dev package is not installed use $arext instead of "a" pattern match for pulling libodbc.* changed warn if DBI_DSN etc not defined change odbc_config output for stderr to /dev/null missing / on /usr/local wheb finding find_dm_hdr_files() New FAQ entries from Oystein Torget for bind parameter bugs in SQL Server. rt_46597.rt - update on wrong table Copied dbivport.h from the latest DBI distribution into DBD::ODBC. Added if_you_are_taking_over_this_code.txt. Add latest Devel::PPPort ppport.h to DBD::ODBC and followed all recommendations for changes to dbdimp.c. Added change to Makefile.PL provided by Shawn Zong to make Windows/Cygwin work again. Minor change to Makefile.PL to output env vars to help in debugging peoples build failures. Added odbc_utf8_on attribute to dbh and sth handles to mark all strings coming from the database as utf8. This is for Aster (based on PostgreSQL) which returns all strings as UTF-8 encoded unicode. Thanks to Noel Burton-Krahn. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com