question

Luka avatar image
Luka asked

DSN (odbc) 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.

mysqlodbclinux
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.