odbc-dbd

Driver for the Apache Portable Runtime to connect via ODBC to various databases.

odbc-dbd is now included in APR 1.3

odbc-dbd is now included in the Apache APR Utilities - apr-util - starting with version 1.3.

Of course I will keep the APR 1.2 version alive here for some time, and address any issues reported with it. Eventually, however, this project will be discontinued.

Projects get discontinued for many reasons of course, but I cannot think of a better reason than having it included in a larger, more well-know project like Apache/APR.

C Source Code (Windows and Unix)

This driver is named apr_dbd_odbc.so on Unix, and apr_dbd_odbc.dll on Windows. It can be used:

• ... with Apache version 2.2.4+ and mod_dbd to perform user authentication against any SQL database which provides ODBC access.

Note that it may be necessary to re-compile Apache to enable DBD drivers as described in the Linux or Windows instructions.

• ... with a program built using the Apache Portable Runtime (APR) version 1.2.8+ to access SQL databases in a database-independent way via the APR DBD module.

Most database vendors provide ODBC drivers

Oracle, PostgreSQL, IBM-DB2, MySQL, Informix, Sybase, SQLServer, MS Access, Foxpro, and many others provide ODBC drivers.

Apache Derby databases can be accessed using the IBM DB2-Connect ODBC driver which is included in IBM DB2 Express-C

Apache 2.2.4 (or later), or APR 1.2.8 (or later) is required for odbc-dbd v1.0.

Modules

Apache 2.2 includes a module for authentication. For access logging and virtual host configuration using DBD, see dbd-modules.

Contact

Visit the discussion group for odbc-dbd.

Please feel free to send email to the Project Owner @gmail.com with ideas, comments, or reports about how odbc-dbd is working for you. There is also a discussion about odbc-dbd in the Apache Lounge Apache/Windows forum.

Release History

• Version 1.3.0 June 16, 2008 - APR 1.3 now includes odbc-dbd.
• Version 1.3.0 May 28, 2008 - Version to work with APR 1.3 or APR 1.4/Apache 2.3 is no longer experimental. CLOB and BLOB datatypes supported. Source for 1.3.x is SVN /trunk. Most users should continue to use odbc-dbd 1.0.x with released versions of Apache 2.2 or APR 1.2.
• Version 1.0.10 March 19, 2008 - Fix problems when a connection is explicitly closed, and an associated statement is closed at a later time. Added support for ODBC-V2 builds and linking with a user-specified ODBC library. Handle NULL CLOBs. Reports the original error when there is a subsequent SQLHANDLE error.
• Version 1.0.9 February 10, 2008 - Fix  Issue #4  - string length when binary SELECT columns are automatically converted to strings.
• Version 1.0.8 January 7, 2008 - Minor Unix build change. gcc 4.1+ requires the '-fno-strict-aliasing' compiler switch. Version 1.0.7 is still current for Windows.
• Version 1.0.7 December 2, 2007 - Better handling of drivers which return "Driver not capable" for column length or octet-length (specifically: Oracle TimesTen ODBC driver).
• Version 1.0.6 November 13, 2007 - Accepts NULL parameters
• Version 1.0.5 October 27, 2007 - Re-packaged into separate Windows and Unix downloads. Updated the GNU autobuild files for Unix. Source for 1.0.x is now SVN /branches/1.0. No functional changes from version 1.0.4.
• Version 1.3.0 October 24, 2007 - Experimental version to work with APR 1.3/Apache 2.3 . Source for 1.3.x is SVN /trunk. Most users should continue to use odbc-dbd 1.0.x with released versions of Apache 2.2 or APR 1.2.
• Version 1.0.4 September 15, 2007 - Fixed  Issue #3  - incorrect argument to cleanup from odbc_select. Open errors are now always written to stderr (i.e. to the Apache error log).
• Version 1.0.3 September 1, 2007 - Improved open error message retention when apr_dbd is initialized from a different thread, also added missing files for Unix build.
• Version 1.0.2 August 12, 2007 - Fixes  Issue #2  - Additional fix for prepared statements close.
• Version 1.0.1 July 10, 2007 - Fixes  Issue #1  - Prepared statements are implicitly closed when connection is closed.