A few weeks back I covered connecting ODBC to MS-SQL, but today we are going to do the same thing with MySQL. The process is very similar. One might ask, why use ODBC driver in the first place? The reason is simple, there are many flavors of SQL and the ODBC driver allows one standard to connect them. For that reason many software developers use ODBC for connecting their applications to SQL.
For my purposes, the Asterisk PBX platform can use ODBC to call ‘dial plan’ functions from the database, but that is another article! This post assumes you have a working MySQL server and at least one table with data to pull from.
Goal of this Post:
- Install ODBC driver for MySQL
- configure odbc.ini
- configure odbcinst.ini
- verify connectivity with isql