MySQL :: MySQL 5.0 Reference Manual :: 20.1.4.5 Configuring a Connector/ODBC DSN on Unix
ODBCConfig
GUI tool (HOWTO: ODBCConfig)
odbcinst
In some cases when using
unixODBC
, you might get this error:Data source name not found and no default driver specifiedIf this happens, make sure the
ODBCINI
andODBCSYSINI
environment variables are pointing to the rightodbc.ini
file. For example, if yourodbc.ini
file is located in/usr/local/etc
, set the environment variables like this:export ODBCINI=/usr/local/etc/odbc.ini export ODBCSYSINI=/usr/local/etc