安装包下载地址:
unixODBC-2.3.1.tar.gz
下载连接:http://www.kuaipan.cn/file/id_50825311541007530.htm
-
centos7上安装和配置
下载一个安装包 uniODBC2.3.1cd /opt
tar -zxvf unixODBC-2.3.1.tar.gz
cd unixODBC-2.3.1
./configure
make
make install安装完后,odbcinst –j 来查看安装位置等信息,如:
unixODBC 2.3.1
DRIVERS…: /usr/local/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
FILE DATA SOURCES…: /usr/local/etc/ODBCDataSources
USER DATA SOURCES…: /root/.odbc.ini
SQLULEN Size…: 8
SQLLEN Size…: 8
SQLSETPOSIROW Size.: 8配置 odbcinst.ini,作用就是注册DM7的ODBC驱动,该驱动名称为DM7,内容如下:
[DM7]
Description = dm odbc
Driver = /opt/dmdbms/bin/libdodbc.so配置 odbc.ini,作用就是创建系统DSN,名称为dm,调用名为DM7的ODBC驱动,内容如下:
[dm]
Description = dm7 dsn
Driver = DM7
SERVER =127.0.0.1
UID = SYSDBA
PWD = SYSDBA
TCP_PORT = 5236配置完成之后,直接在终端运行:isql dm
来测试,如果返回以下信息,测说明配置成功:
[root@localhost opt]# isql dm
±--------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
±--------------------------------------+
SQL> select 1;