unable to connect to the database: Can't open lib 'MySQL ODBC 3.51 Driver'

[shravankumar147]

Issue

unable to connect with the database:
Error:
('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'MySQL ODBC 3.51 Driver' : file not found (0) (SQLDriverConnect)")

Environment

• Python: 2.7
• pyodbc: latest from pip install
• OS: ubuntu 16.04 x64
• DB:MySQL
• driver:MySQL ODBC 3.51 Driver

[gordthompson]

Have you actually installed the ODBC driver for MySQL? If so, did you register the driver so that it appears in odbcinst.ini, for example:

[MySQL ODBC 3.51 Driver]
Driver=/home/gord/Downloads/mysql-connector-odbc-3.51.30-linux-glibc2.3-x86-64bit/lib/libmyodbc3.so
UsageCount=1

You should be able to use the odbcinst -j command to check the location of odbcinst.ini. On Ubuntu it is typically /etc/odbcinst.ini.

[shravankumar147]

Tried and worked Thanks