How to list available UnixODBC drivers?

When you get error messages such as

odbc_drivers.txt
[unixODBC][Driver Manager]Can't open lib '...' : file not found

It is often useful to list all available drivers to see if the driver you are trying to use is not installed or you’ve just made a typo.

To list all available drivers, you can use the odbcinst command:

list_unixodbc_drivers.sh
odbcinst -q -d

Example output:

example.txt
[PostgreSQL ANSI]
[PostgreSQL Unicode]
[MariaDB Unicode]

Check out similar posts by category: Databases