Linux环境下配置达梦数据库ODBC

1.操作系统已经安装unixODBC环境

1.查看操作系统上查看ODBC版本

[dmdba@localhost]# odbc_config --version

2.3.0

2.查看ODBC配置文件存放的位置

[root@localhost etc]# odbc_config --odbcini
/etc/odbc.ini
[root@localhost etc]# odbc_config --odbcinstini
/etc/odbcinst.ini

3.修改odbc.ini文件

[dmdba@localhost]# vi /etc/odbc.ini

[dm]

Description = DM ODBC DSN

Driver = DM7 ODBC DRIVER

SERVER = localhost

UID = SYSDBA

PWD = SYSDBA

TCP_PORT = 5236

4.修改odbcinst.ini文件

[dmdba@localhost]# vi /etc/odbcinst.ini

[DM7 ODBC DRIVER]

Description = ODBC DRIVER FOR DM7

Driver = /opt/dmdbms/bin/libdodbc.so

5.测试连接

[root@localhost]# disql dm SYSDBA SYSDBA

+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+

2. 操作系统未安装unixODBC环境

1.将附件unixODBC-2.3.0.tar.gz上传到/usr/local下，执行安装。

[root@localhost local]# tar -xzvf unixODBC-2.3.0.tar.gz

[root@localhost unixODBC-2.3.0]# cd unixODBC-2.3.0

[root@localhost unixODBC-2.3.0]# ./configure --enable-gui=no

[root@localhost unixODBC-2.3.0]# make

[root@localhost unixODBC-2.3.0]# make install

2.查看操作系统上查看ODBC版本

[dmdba@localhost]# odbc_config --version

2.3.0

3.查看ODBC配置文件存放的位置

[root@localhost etc]# odbc_config --odbcini
/etc/odbc.ini
[root@localhost etc]# odbc_config --odbcinstini
/etc/odbcinst.ini

4.修改odbc.ini文件

[dmdba@localhost]# vi /etc/odbc.ini

[dm]

Description = DM ODBC DSN

Driver = DM7 ODBC DRIVER

SERVER = localhost

UID = SYSDBA

PWD = SYSDBA

TCP_PORT = 5236

5.修改odbcinst.ini文件

[dmdba@localhost]# vi /etc/odbcinst.ini

[DM7 ODBC DRIVER]

Description = ODBC DRIVER FOR DM7

Driver = /opt/dmdbms/bin/libdodbc.so

6.测试连接

[root@localhost]# disql dm SYSDBA SYSDBA

+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+