linux上配置达梦ODBC

root下进行达梦odbc包的解压
[root@node1 /]# tar -zxvf unixODBC-2.3.0.tar.gz

进行配置、编译、安装

[root@node1 /]# cd unixODBC-2.3.0

[root@node1 unixODBC-2.3.0]# ls

acinclude.m4  config.status  DriverManager  install-sh  Makefile       README.AIX      stamp-h1

aclocal.m4    config.sub     Drivers        Interix     Makefile.am    README.CYGWIN   vms

AUTHORS       configure      DRVConfig      libltdl     Makefile.in    README.INTERIX  vmsbuild.com

ChangeLog     configure.in   exe            libtool     missing        README.OSX      ylwrap

config.guess  COPYING        extras         log         mkinstalldirs  README.QNX

config.h      cur            include        lst         NEWS           README.SOLARIS

config.h.in   depcomp        ini            ltmain.sh   odbcinst       README.VMS

config.log    doc            INSTALL        m4          README         samples

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

[root@node1 unixODBC-2.3.0]# make

[root@node1 unixODBC-2.3.0]# make install

配置 odbc.ini数据源信息和 odbcinst.ini驱动信息

[root@node1 unixODBC-2.3.0]# cd /usr/local/etc/

[root@node1 etc]# ls

ODBCDataSources  odbc.ini  odbcinst.ini

[root@node1 etc]# more odbc.ini

[DM8]

Description =DM ODBC DSN

Driver =DM8 ODBC DRIVER

SERVER = localhost

UID = SYSDBA

PWD = SYSDBA

TCP_PORT = 5236

[root@node1 etc]# more odbcinst.ini

[DM8 ODBC DRIVER]

Description =ODBC DRIVER FOR DM8

Driver =/dm8/bin/libdodbc.so

切换到dmdba用户进行连接测试

[root@node1 etc]# su - dmdba

[dmdba@node1 ~]$ isql dm8 -v

+---------------------------------------+

| Connected!                            |

|                                       |

| sql-statement                         |

| help [tablename]                      |

| quit                                  |

|                                       |

+---------------------------------------+

SQL> select count(*) from v$datafile ;

+------------+

| COUNT(*)   |

+------------+

| 7          |

+------------+

SQLRowCount returns 1

1 rows fetched

root下执行报错是因为环境变量中未配置LD_LIBRARY_PATH

[root@node1 ~]# isql dm8 -v

[01000][unixODBC][Driver Manager]Can't open lib '/dm8/bin/libdodbc.so' : file not found

[ISQL]ERROR: Could not SQLConnect

达梦社区地址：https://eco.dameng.com