麒麟v10配置ODBC并测试连接DM8

odbc的安装包可以从资料包中下载

一、x86环境

1. 安装odbc

[root@localhost ~]# tar -xvf unixODBC-2.3.0.tar.gz -C /usr/local
[root@localhost ~]# cd /usr/local
[root@localhost ~]# cd /usr/local/unixODBC-2.3.0
[root@localhost ~]# ./configure --prefix=/usr/local/unixODBC
[root@localhost ~]# make
[root@localhost ~]# make install

## 提示，odbc写c成的时候会用到
##  缺省UnixODBC安装在/usr/local目录下，库文件在/usr/local/unixODBC/lib目录下
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/unixODBC/lib

2. 修改odbc的配置文件

[root@localhost ~]# /usr/local/unixODBC/etc/odbcinst.ini
[DM8 ODBC DRIVER]
Description=DM ODBC driver for DM8
Driver=/opt/dmdbms_1_2_198_test/bin/libdodbc.so
[root@localhost ~]# /usr/local/unixODBC/etc/odbc.ini
[DM8]
DRIVER=DM8 ODBC DRIVER
SERVER=127.0.0.1
UID=SYSDBA
PWD=SYSDBA
TCP_PORT=5236

二、arm环境

1. 安装odbc

[root@localhost ~]#  tar -xvf unixODBC-2.3.0.tar.gz -C /usr/local
[root@localhost ~]#  cd /usr/local
[root@localhost ~]#  cd /usr/local/unixODBC-2.3.0
[root@localhost ~]#  ./configure --prefix=/usr/local/unixODBC-arm --enable-gui=no --build=arm-linux-gnueabihf
[root@localhost ~]#  make
[root@localhost ~]#  make install

2. 修改odbc的配置文件

[root@localhost ~]# cat /usr/local/unixODBC-arm/etc/odbcinst.ini
[DM8 ODBC DRIVER]
Description=DM ODBC driver for DM8
Driver=/opt/dmdbms_1_2_198_test/bin/libdodbc.so
[root@localhost ~]# cat /usr/local/unixODBC-arm/etc/odbc.ini
[DM8]
DRIVER=DM8 ODBC DRIVER
SERVER=127.0.0.1
UID=SYSDBA
PWD=SYSDBA
TCP_PORT=5236

三、调用odbc

[root@localhost ~]# isql DM8 SYSDBA SYSDBA -v
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> 

Q&A

1. 修改odbc的默认指向

[root@localhost ~]# cd /usr/local/unixODBC-2.3.0/exe
[root@localhost ~]# cp -r isql /usr/bin/
[root@localhost ~]# isql DM8 SYSDBA SYSDBA

2.运行odbc的c程序时需指明库文件路径

注：使用isql连接测试时，连不上数据库，则检查路径是否有指向DM7的bin目录：
export LD_LIBRARY_PATH=/home/dmdba/dmdbms/bin:$LD_LIBRARY_PATH

资料

资料包

链接：https://pan.baidu.com/s/1moVsFmCW4Wc3SvOxgFtqbw?pwd=zhpv
提取码：zhpv