yum install -y unix*
rpm -ivh unixODBC-2.3.1-10.el7.x86_64.rpm
添加配置文件
vi /etc/template_file1
[KingbaseES 8 ODBC Driver]Description = KingbaseES 8 ODBC Driver for LinuxDriver = /KingbaseES/V8/Interface/odbc/kdbodbcw.soDebug = 0CommLog = 1
chown kingbase:kingbase template_file1
初始化驱动
odbcinst -i -d -f template_file1
添加kingbase 配置文件
vim /etc/template_file2
[kingbase]Description = KingbaseESDriver = KingbaseES 8 ODBC DriverTrace = NoTraceFile =Database = TESTServername = 192.168.40.111Username = SYSTEMPassword = kingbasePort = 54321ReadOnly = NoRowVersioning = NoShowSystemTables = NoShowOidColumn = NoFakeOidIndex = NoConnSettings =
创建odbc数据源
odbcinst -i -s -f template_file2
测试验证odbc连接
isql kingbase
±-------------------------------+
| Connected! |
| sql-statement |
| help [tablename] |
| quit |