MySQL Forums
Forum List  »  Connector/ODBC

DSN Configuration on Centos: Wrong or unknown protocol
Posted by: Luka Lauk
Date: October 07, 2021 06:10AM

A DSN 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.

Options: ReplyQuote


Subject
Written By
Posted
DSN Configuration on Centos: Wrong or unknown protocol
October 07, 2021 06:10AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.