odbc 连接dm8数据库

odbc 连接dm8数据库

windows 连接dm8

1. 在windos上搜索odbc数据源
   

2. 打开odbc程序，选择系统dns，选择添加
   

3. 选择dm驱动
   

4. 填写相关配置
   

5. 点击测试
   

6. 点击确定推出

linxu安装odbc

1. 下载odbc
   

2. 解压

   [root@oracle ~]# tar  -xvf unixODBC-2.3.9.tar.gz
   

3. 编译odbc

   [root@oracle ~]# cd unixODBC-2.3.9
   [root@oracle ~]# ./configure
   [root@oracle ~]# make
   [root@oracle ~]# make install
   

4. 查看参数的位置

   [root@oracle ~]# odbcinst -j
   unixODBC 2.3.9
   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
   
   

5. 编辑参数配置文件

   [root@oracle ~]# cat /usr/local/etc/odbc.ini
   [dm]
   Description=DM ODBC DSND
   Driver=DM8 ODBC DRIVER
   SERVER=localhost
   UID=SYSDBA
   PWD=Dameng123
   TCP_PORT=8881
   
   

6. 编辑驱动配置文件

   [root@oracle etc]# cat /usr/local/etc/odbcinst.ini
   [DM8 ODBC DRIVER]
   Description=ODBC DRIVER FOR DM8
   DRIVER=/dm8/drivers/odbc/libdodbc.so
   
   

7. 连接dm8

   [dmdba@oracle ~]$ isql dm
   +---------------------------------------+
   | Connected!                            |
   |                                       |
   | sql-statement                         |
   | help [tablename]                      |
   | quit                                  |
   |                                       |
   +---------------------------------------+
   SQL> select * from dual;
   +------+
   | DUMMY|
   +------+
   | X    |
   +------+
   SQLRowCount returns 1
   1 rows fetched
   SQL> quit