[S1000][unixODBC][MySQL][ODBC 8.0(w) Driver]Bad handshake
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.
Subject
Written By
Posted
[S1000][unixODBC][MySQL][ODBC 8.0(w) Driver]Bad handshake
February 20, 2019 03:44AM
February 28, 2019 03:55AM
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.