centos9 64位 odbc切换到9.0版本教程

ODBC下载地址:mysql-connector-odbc-9.1.0-1.el9.x86_64.rpm

上传到/opt目录下后进行操作:

安装命令:

cd /opt
dnf install mysql-connector-odbc-9.1.0-1.el9.x86_64.rpm

修改配置文件

\etc\odbc.ini

[tlbb_tserver]
Driver = /usr/lib64/libmyodbc9a.so
SERVER = 127.0.0.1
PORT = 3306
USER = root
Password = 123456
Database = tlbb_tserver
OPTION = 3
SOCKET =

[tlbbdb_main]
Driver = /usr/lib64/libmyodbc9a.so
SERVER = 127.0.0.1
PORT = 3306
USER = root
Password = 123456
Database = tlbbdb_main
OPTION = 3
SOCKET =

[tlbbdb_10]
Driver = /usr/lib64/libmyodbc9a.so
SERVER = 127.0.0.1
PORT = 3306
USER = root
Password = 123456
Database = tlbbdb_10
OPTION = 3
SOCKET =

[tlbbdb_11]
Driver = /usr/lib64/libmyodbc9a.so
SERVER = 127.0.0.1
PORT = 3306
USER = root
Password = 123456
Database = tlbbdb_11
OPTION = 3
SOCKET =