ODBC error - libmyodbc8w.so' : file not found

If you encounter the ODBC error libmyodbc8w.so' : file not found in the Asterisk CLI:

^[[31m[2024-09-04 15:53:09] [ERROR] agi > Error getting ODBC connection [Error: [odbc] Error connecting to the database] {^[[39m
^[[31m  odbcErrors: [^[[39m
^[[31m    {^[[39m
^[[31m      state: '01000',^[[39m
^[[31m      code: 0,^[[39m
^[[31m      message: "[unixODBC][Driver Manager]Can't open lib '/usr/lib/x86_64-linux-gnu/odbc/libmyodbc8w.so' : file not found"^[[39

Check in cat /etc/odbcinst.ini if this line is present:

Driver=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc8w.so

If yes proceed by modifying it as follows:

Driver=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc9w.so

UsageCount=1