MySQL Forums
Forum List  »  Connector/ODBC

[S1000][unixODBC][MySQL][ODBC 8.0(w) Driver]Bad handshake
Posted by: Aleksey Makaenko
Date: February 20, 2019 03:44AM

Client:
Oracle Solaris 11.4 SPARC
The UnixODBC Subsystem and SDK Version: 2.3.6 Branch: 11.4.2.0.1.1.0
MySQL Connector/ODBC 8.0 (Commercial)(sparc) 8.0.15

Server:
MySQL 5.1.66
UTF-8 Unicode (utf8)


# ldd /opt/mysql/myodbc8/lib/libmyodbc8w.so
libstdc++.so.6 => /opt/developerstudio12.6/lib/compilers/CC-gcc/lib/sparcv9/libstdc++.so.6
libgcc_s.so.1 => /opt/developerstudio12.6/lib/compilers/CC-gcc/lib/sparcv9/libgcc_s.so.1
libCrunG3.so.1 => /usr/lib/64/libCrunG3.so.1
libodbcinst.so.2 => /usr/lib/64/libodbcinst.so.2
libc.so.1 => /lib/64/libc.so.1
libstatomic.so.1 => /opt/developerstudio12.6/lib/compilers/atomic/sparcv9/libstatomic.so.1
libsocket.so.1 => /lib/64/libsocket.so.1
libnsl.so.1 => /lib/64/libnsl.so.1
libm.so.2 => /lib/64/libm.so.2
libssl.so.1.0.0 => /lib/64/libssl.so.1.0.0
libcrypto.so.1.0.0 => /lib/64/libcrypto.so.1.0.0
librt.so.1 => /lib/64/librt.so.1
libltdl.so.7 => /usr/lib/64/libltdl.so.7

# cat /etc/odbc/odbc.ini
[ODBC Data Sources]
samplednsname = ODBC for MySQL

[samplednsname]
Driver = /opt/mysql/myodbc8/lib/libmyodbc8w.so
SERVER = server
PORT = 3306
DATABASE = database
OPTION = 3
USER = user
PASSWORD = password
SSLMODE = DISABLED

# cat odbcinst.ini
[ODBC Drivers]
MySQL = Installed

[MySQL]
Description = ODBC for MySQL
Driver = /opt/mysql/myodbc8/lib/libmyodbc8w.so
Threading = 0

When connecting, an error occurs:

# isql -v samplednsname
[S1000][unixODBC][MySQL][ODBC 8.0(a) Driver]Bad handshake
[ISQL]ERROR: Could not SQLConnect


Help solve the problem.

Options: ReplyQuote


Subject
Written By
Posted
[S1000][unixODBC][MySQL][ODBC 8.0(w) Driver]Bad handshake
February 20, 2019 03:44AM


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.