配置ODBC

rpm -q gcc
tar xzvf unixODBC-2.3.0.tar.gz
cd unixODBC-2.3.0/
./configure --enable-gui=no
make && make install
odbc_config -j
odbc_config --odbcini
odbc_config --odbcinstini
vim /usr/local/etc/odbc.ini
[dm8]
description=dm8
driver=odbc dm8
server=192.168.6.110
uid=sysdba
pwd=EnmoEdu123
tcp_port=5252

vim /usr/local/etc/odbcinst.ini
[odbc dm8]
description=odbc dm8
driver=/opt/dm8/drivers/odbc/libdodbc.so

[dmdba@enmoedu1 ~]$ isql dm8
+---------------------------------------+
Connected!
sql-statement
help [tablename]
quit

+---------------------------------------+
SQL>

配置ODBC

上一篇:数据库_分组函数_分组查询


下一篇:TOP SQL监控之oracle篇