"2016-09-14T12:28:33Z" . . . "2016-09-14T12:28:33.630858"^^ . . . . . . "MySQL2ODBC" . . . . . . "2022-12-16T17:08:09Z" . . . "---+ MySQL-to-ODBC Gateway\r\n\r\n%TOC%\r\n\r\n---++ Introduction\r\n\r\n---+++ What Is It?\r\n\r\nMySQL2ODBC is a library for intercepting MySQL API calls and redirecting them via ODBC.\r\n\r\n---+++ Why?\r\n\r\nHistorically the open-source community has produced many useful applications tied to the LAMP stack (Linux, Apache, MySQL and PHP) or similar variants. Often, however, the reliance on MySQL as the database layer of choice has been baked-in with little scope for substituting another RDBMS.\r\n\r\nOn the other hand, ODBC has long provided flexible choice of backend RDBMS - by talking ODBC, an application can switch between PostgreSQL, MySQL, Oracle, SQL Server, OpenLink Virtuoso and many more at will.\r\n\r\nMySQL2ODBC is one way to break free of vendor lock-in and restore database-independence via ODBC :)\r\n\r\n---+++ Benefits\r\n\r\n * Cost-Effectiveness - MySQL2ODBC saves having to rewrite the whole database access layer in a potentially large application\r\n * Database-Independence: Freedom of Choice\r\n\r\n\r\n---++ HOWTO\r\n\r\nMySQL2ODBC provides a substitute libmysqlclient library.\r\n\r\n---+++ Method\r\n\r\n---++++ Building MySQL2ODBC\r\n\r\n * Download mysql2odbc-0.99.2.tar.gz\r\n * unpack it somewhere in your usual source directory tar xvpfz mysql2odbc-0.99.2.tar.gz\r\n * check the options to configure by running ./configure --help - you can choose which ODBC Driver Manager to work with, either unixODBC or iODBC\r\n * ./configure --with-iodbc=/usr/local/iodbc --prefix=/usr/local/mysql2odbc\r\n * make\r\n * sudo make install\r\n\r\n---++++ Deploying MySQL2ODBC\r\n\r\nYour application needs to be told to use the MySQL2ODBC implementation of libmysqlclient in preference to the existing version. To do this, either\r\n\r\nexport LD_LIBRARY_PATH=/usr/local/mysql2odbc/lib\r\n\r\nor\r\n\r\nexport LD_PRELOAD=/usr/local/mysql2odbc/lib/libmysqlclient.so\r\n\r\nand restart the application. You might want to create a shell-script wrapper to preserve this.\r\n\r\n---++ Download & License\r\n\r\nThe source can be downloaded from github as a zip archive: [[https://github.com/openlink/mysql2odbc/archive/refs/heads/develop.zip][MySQL2ODBC source zip]].\r\n\r\nAlternatively you can clone the repository:\r\n\r\ngit clone https://github.com/openlink/mysql2odbc.git\r\n\r\nThe project is licensed under the terms of the GNU [[https://www.gnu.org/licenses/old-licenses/lgpl-2.0.html][Library General Public License (LGPL) v2]].\r\n\r\nPatches are welcomed - please either send us a merge request via github or email the OpenLink iODBC source archive manager at iodbc@openlinksw.com, including documentation. Thank you for your contributions :)" . . . . . . "MySQL2ODBC" . "MySQL2ODBC" . "2022-12-16T17:08:09.131692"^^ . "5cf1b9707fab794ac8d4e7f34c008126" .