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:

Driver = /usr/lib64/
Description = Connector/ODBC 8.0 ANSI Driver DSN
SERVER = serveradress
PORT = 3306
USER = user
Password = password
Database = DBName
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

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

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.