A DSN (odbc) configuration on Centos Linux 7 is not working anymore.
I am not sure if this was caused by an OS update or similar.
When testing the DSN configuration by using the isql command, the following output is produced:
[root@server etc]# isql -v DSNDGESQL01pflAnsi
[S1000][unixODBC][MySQL][ODBC 8.0(a) Driver]Wrong or unknown protocol
[ISQL]ERROR: Could not SQLConnect
The DSN configuration looks as follows:
[DSNDGESQL01pflAnsi]
Driver = /usr/lib64/libmyodbc8a.so
Description = Connector/ODBC 8.0 ANSI Driver DSN
SERVER = serveradress
CHARSET = UTF8MB4
PORT = 3306
USER = user
Password = password
Database = DBName
OPTION = 4
SOCKET = /var/lib/mysql/mysql.sock
The Server can connect to the SQL server through mySQL Shell with the same adress, user and password as provided in the DSN configuration.
I could not find anything explaining where a "wrong protocol" was provided.
Has anyone ever experienced a similar issue?
Kind regards.