The State of Data::ODBC
For those folks who have expressed interest in Data library, I’ve been spending some time these days with it and here is the current state of the affairs:
– I found a couple of bugs (logged in SF):
Drivers passing all tests:
Windows: MS Access, DB2, Oracle, MySQL, PostgreSQL, SQLServer, SQLite3
Linux (unixODBC): PostgreSQL, MySQL
If you are running on Linux, I strongly recommend to check out the recent SVN. Windows users should have no trouble with either 1.3 release archive or SVN code.
On Linux, FreeTDS connects to MS SQLServer but unfortunately bombs right on the barebone ODBC test, which likely means that the driver is either buggy or nonconformant (barebone ODBC test runs pure ODBC API calls without going through Data library). If anyone can find some time to track down what’s going wrong there, it will be appreciated. Given the amount of components involved (OS, ODBC driver manager, ODBC driver, database) it is practically impossible to test every combination, but we strive to have the most common cases covered.
In the meantime , I am working on stored procedure call support, configurable internal storage containers, DateTime binding etc for 1.3.1.
Until later,
Alex