You should have similar output if run these commands
Verify the DNS connection
root@vultr:~# asterisk -x " odbc show"
ODBC DSN Settings
Name: asterisk-mysql
DSN: asterisk-mysql
Number of active connections: 1 (out of 1)
ALSO the driver configuration
echo “select 1” | isql -v asterisk-mysql
±--------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
±--------------------------------------+
SQL> select 1
±--------------------+
| 1 |
±--------------------+
| 1 |
±--------------------+
SQLRowCount returns 1
1 rows fetched