安装配置ODBC
1、将odbc安装包放置到服务器opt目录下,解压,命令如下:
[root@localhost opt]# ls
dm8_20231109_x86_kylin10_64.iso firefox patch_workspace unixODBC-2.3.0.tar.gz
[root@localhost opt]# tar -xvf unixODBC-2.3.0
[root@localhost opt]# ls
dm8_20231109_x86_kylin10_64.iso firefox patch_workspace unixODBC-2.3.0 unixODBC-2.3.0.tar.gz
[root@localhost opt]#
2、执行configure脚本配置环境,生成了Makefile:
[root@localhost unixODBC-2.3.0]# ./configure
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for a thread-safe mkdir -p... /usr/bin/mkdir -p
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
...
3、编译安装,默认安装路径为/usr/local/
[root@localhost unixODBC-2.3.0]# make && make install
make all-recursive
make[1]: 进入目录“/opt/unixODBC-2.3.0”
Making all in extras
make[2]: 进入目录“/opt/unixODBC-2.3.0/extras”
...
4、配置odbc连接文件odbc.ini、odbcinst.ini,如下所示:
[root@localhost ~]# cd /usr/local/etc/
[root@localhost etc]# cat odbc.ini
[DM8]
Description =DM ODBC DSN
Driver =DM8 ODBC DRIVER //和odbcinst.ini文件组名保持一致
SERVER =localhost
UID =SYSDBA
PWD =SYSDBA
TCP_PORT =5236
[root@localhost etc]# cat odbcinst.ini
[DM8 ODBC DRIVER]
Description =ODBC DRIVER FOR DM8
Driver =/home/dmdba/dmdbms/bin/libdodbc.so
[root@localhost etc]#
注意:odbc.ini文件中Driver值需要和odbcinst.ini文件组名保持一致,示例中皆为DM8 ODBC DRIVER
5、使用dmdba用户测试连接:
[root@localhost ~]# su - dmdba
上一次登录: 四 8月 1 22:57:51 CST 2024 pts/0 上
[dmdba@localhost ~]$ isql dm8
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>