SQLTeam.com | Weblogs | Forums

DSN Configuration on Centos: Wrong or unknown protocol

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.