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.
Subject
Written By
Posted
DSN Configuration on Centos: Wrong or unknown protocol
October 07, 2021 06:10AM
December 06, 2021 02:38AM
Sorry, you can't reply to this topic. It has been closed.
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.