This HTML5 document contains 28 embedded RDF statements represented using HTML+Microdata notation.

The embedded RDF content will be recognized by any processor of HTML5 Microdata.

Subject Item

n2:MySQL2ODBC

rdf:type

sioct:Comment atom:Entry

dcterms:created

2016-09-14T12:28:33.630858

dcterms:modified

2022-12-16T17:08:09.131692

rdfs:label

MySQL2ODBC

foaf:maker

n5:this n8:this

n19:has_services

n20:item

dc:title

MySQL2ODBC

sioc:link

n2:MySQL2ODBC

sioc:id

5cf1b9707fab794ac8d4e7f34c008126

opl:isDescribedUsing

n13:rdf

sioc:links_to

n10:OpenLink n10:MySQL n2:MySQL2ODBC n14:html n10:PostgreSQL n16:zip

sioc:has_creator

n17:this n18:this

sioc:has_container

n6:iodbcWiki

atom:source

n6:iodbcWiki

atom:title

MySQL2ODBC

atom:author

n8:this

atom:published

2016-09-14T12:28:33Z

atom:updated

2022-12-16T17:08:09Z

sioc:content

---+ MySQL-to-ODBC Gateway %TOC% ---++ Introduction ---+++ What Is It? MySQL2ODBC is a library for intercepting MySQL API calls and redirecting them via ODBC. ---+++ Why? Historically 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. On 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. MySQL2ODBC is one way to break free of vendor lock-in and restore database-independence via ODBC :) ---+++ Benefits * Cost-Effectiveness - MySQL2ODBC saves having to rewrite the whole database access layer in a potentially large application * Database-Independence: Freedom of Choice ---++ HOWTO MySQL2ODBC provides a substitute libmysqlclient library. ---+++ Method ---++++ Building MySQL2ODBC * Download mysql2odbc-0.99.2.tar.gz * unpack it somewhere in your usual source directory <verbatim>tar xvpfz mysql2odbc-0.99.2.tar.gz</verbatim> * check the options to configure by running <code>./configure --help</code> - you can choose which ODBC Driver Manager to work with, either unixODBC or iODBC * <verbatim>./configure --with-iodbc=/usr/local/iodbc --prefix=/usr/local/mysql2odbc</verbatim> * <verbatim>make</verbatim> * <verbatim>sudo make install</verbatim> ---++++ Deploying MySQL2ODBC Your application needs to be told to use the MySQL2ODBC implementation of libmysqlclient in preference to the existing version. To do this, either <verbatim><nowiki>export LD_LIBRARY_PATH=/usr/local/mysql2odbc/lib</nowiki></verbatim> or <verbatim><nowiki>export LD_PRELOAD=/usr/local/mysql2odbc/lib/libmysqlclient.so</nowiki></verbatim> and restart the application. You might want to create a shell-script wrapper to preserve this. ---++ Download &amp; License The source can be downloaded from github as a zip archive: [[https://github.com/openlink/mysql2odbc/archive/refs/heads/develop.zip][MySQL2ODBC source zip]]. Alternatively you can clone the repository: <verbatim><nowiki>git clone https://github.com/openlink/mysql2odbc.git</nowiki></verbatim> The 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]]. Patches are welcomed - please either send us a merge request via github or email the OpenLink iODBC source archive manager at <a href="mailto:iodbc&#64;openlinksw.com">iodbc&#64;openlinksw.com</a>, including documentation. Thank you for your contributions :)

sioc:topic

n6:iodbcWiki