Hi!

MyODBC 3.51 driver was released a few days ago.

Version 3.51 of the MyODBC driver is now released by MySQL AB and available for download. An ODBC (Open Database Connectivity) driver enables client programs to access a database or data source. The new version 3.51 MySQL ODBC driver is a greatly enhanced successor version to the existing MyODBC 2.50, rewritten to follow the ODBC 3.5x specifications. It provides complete and up-to-date ODBC functionality when accessing any MySQL database.

Changelog and API reference for MyODBC 3.51.01:

-- SQLAllocHandle -- SQLFreeHandle -- SQLSetEnvAttr, using this, the driver can be configured its functionality based on the ODBC version -- SQLGetEnvAttr -- SQLSetConnectAttr -- SQLGetConnectAttr -- SQLSetStmtAttr -- SQLGetStmtAttr -- SQLFetchScroll -- SQLBulkOperations with SQL_ADD (Bulk Inserts) -- SQLGetDiagRec -- SQLGetDiagField -- SQLCloseCursor -- SQLEndTran -- SQLGetInfo, re-written completly -- SQLGetFunctions, re-written completly -- Complete changes to error handling. Also driver returns the SQLSTATE values based on the ODBC version. -- Support of dynamic cursor type -- Enhanced cursor handling -- Changed SQLGetTypeInfo to return column headers as per 3.5 spec -- Changed all catalog APIs to return column headers as per 3.5 spec -- Support of dynamic cursor type -- New feature called 'Test Data Source' in the DSN setup dialog, so that the DSN settings can be tested while configuring. -- Added 'HELP' button to DSN setup dialog, which links to online MyODBC manual. -- Added SOCKET option to SQLConnect API i.e. in odbc.ini -- Support of depricated API 'SQLParamOptions' so that one can supply batch parameter processing with 2.x applications -- Added server name and version to the statement error prfix i.e. the error prfix looks something like [MySQL][ODBC 3.51 Driver][mysqld-3.23.46-max] -- Added SOCKET option to SQLConnect API i.e. in odbc.ini -- Fix to SQL_FETCH_RELATIVE from SQLExtendedFetch or SQLFetchScroll, to handle the following cases:

- BeforeStart AND FetchOffset <= 0 - CurrRowsetStart = 1 AND FetchOffset < 0 - CurrRowsetStart > 1 AND CurrRowsetStart + FetchOffset < 1 AND |FetchOffset| > RowsetSize - CurrRowsetStart > 1 AND CurrRowsetStart + FetchOffset < 1 AND |FetchOffset| <= RowsetSize

-- Fix to SQL_FETCH_RELATIVE from SQLExtendedFetch or SQLFetchScroll, to handle the case when

FetchOffset < 0 AND |FetchOffset| > LastResultRow AND |FetchOffset| > RowsetSize

-- Fix to memory leaks on unix when linked with iodbc or unixodbc. -- Support of depricated API 'SQLParamOptions' so that one can supply batch parameter processing with 2.x applications -- Added server name and version to the statement error prfix i.e. the error prfix looks something like [MySQL][ODBC 3.51 Driver][mysqld-3.23.46-max] -- FILEDSN support

Apart from the above,

-- MyODBC 3.51 allows backward compatibility, i.e. all 2.50 applications will work without any problems. -- MySQL ODBC 3.51 Programmer's Reference Manual and frequently Asked Questions(FAQs) are live.

For more information about MyODBC, visit http://www.mysql.com/products/myodbc/index.html

Regards Venu & Monty