麒麟v10配置ODBC并測試連接配接DM8一、x86環境二、arm環境三、調用odbcQ&A

odbc的安裝包可以從資料包中下載下傳

一、x86環境

1. 安裝odbc

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

## 提示，odbc寫c成的時候會用到
##  預設UnixODBC安裝在/usr/local目錄下，庫檔案在/usr/local/unixODBC/lib目錄下
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/unixODBC/lib
           

2. 修改odbc的配置檔案

[[email protected] ~]# /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
[[email protected] ~]# /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

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

2. 修改odbc的配置檔案

[[email protected] ~]# 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
[[email protected] ~]# 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

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

           

Q&A

1. 修改odbc的預設指向

[[email protected] ~]# cd /usr/local/unixODBC-2.3.0/exe
[[email protected] ~]# cp -r isql /usr/bin/
[[email protected] ~]# 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