ODBC数据源配置

1.linux ODBC配置

1.1上传安装包解压

tar -zxvf unixODBC-2.3.0.tar.gz

1.2编译

[root@dca unixODBC-2.3.0]# ./configure

需要安装gcc。

1.3安装

[root@dca unixODBC-2.3.0]# make & make install

1.4查看配置文件路径

[root@dca unixODBC-2.3.0]# odbcinst -j unixODBC 2.3.0 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

1.5修改配置文件

/usr/local/etc/odbc.ini

[DM8] Description = DM ODBC DSN Driver = DM8 ODBC DRIVER SERVER = localhost UID = SYSDBA PWD = 123456789 TCP_PORT = 5236

/usr/local/etc/odbcinst.ini

[DM8 ODBC DRIVER] Description = ODBC DRIVER FOR DM8 Driver = /dm/dmdbms/bin/libdodbc.so

1.6测试

[dmdba@dca ~]$ isql dm8 -v open fail! path:./libcrypto.so +---------------------------------------+ | Connected!                            | |                                       | | sql-statement                         | | help [tablename]                      | | quit                                  | |                                       | +---------------------------------------+ SQL> select count(*) from tb1; +---------------------+ | COUNT(*)            | +---------------------+ | 4                   | +---------------------+ SQLRowCount returns 1 1 rows fetched

2.windows配置

打开管理工具

DM安装程序会自动注册DM的ODBC驱动

添加系统DSN

测试数据源

显示成功，则表示配置完成生效。 更多资讯请上达梦技术社区了解：https://eco.dameng.com