K-DB之odbc连接kdb简单测试

1.环境说明

OS：CentOS7.8
DB：Inspur K-DB 11 (DB 6.0 FS07_CS_1912)
DB_NAME：kdb
账密：sys/kdb

2.安装iodbc与配置
2.1 下载iodbc

安装包：libiodbc-3.52.12.tar.gz
下载地址：https://sourceforge.net/projects/iodbc/files/latest/download

2.2 安装iodbc

[kdb@kdbtest ~]$ tar -xzvf libiodbc-3.52.6.tar.gz
[kdb@kdbtest ~]$ cd libiodbc-3.52.7
[kdb@kdbtest ~]$ ./configure --prefix=$HOME/iodbc --disable-gui

[kdb@kdbtest ~]$ make && make install
[kdb@kdbtest ~]$ cd iodbc
[kdb@kdbtest ~]$ mkdir kdlib
[kdb@kdbtest ~]$ cp $KD_HOME/client/lib/libkdodbc.so /home/kdb/iodbc/kdlib

2.3 配置iodbc

[kdb@kdbtest ~]$ vim .bash_profile
添加内容如下：
export LD_LIBRARY_PATH=$KD_HOME/lib:$KD_HOME/client/lib:/home/kdb/iodbc/lib:/home/kdb/iodbc/kdlib:$LD_LIBRARY_PATH
 export PATH=$KD_HOME/bin:$KD_HOME/client/bin:/home/kdb/iodbc/bin:$PATH
[kdb@kdbtest ~]$ source .bash_profile

3.编写odbc标准程序
在$HOME目录下创建.odbc.ini 文件,内容如下，

Inspur11                =Inspur11 ODBC driver

[ODBC]
Trace   =1
Trace   =/home/kdb/iodbc/tmp/odbc.trace

[Inspur11]
Driver  =/home/kdb/iodbc/kdlib/libkdodbc.so
Description     =Inspur ODBC Datasource
SID     =kdb
User    =sys
Password =kdb

5.测试连接并查询

[kdb@kdbtest ~]$ iodbctest "DSN=Inspur11;UID=sys;PWD=kdb"
iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.1216.0712
Driver: 11.00.0215 (libkdodbc.so)

SQL>select * from dual;
DUMMY
-----
X    
 result set 1 returned 1 rows.
SQL>