我的达梦 odbc 配置-凯发app官方网站

root用户登录
cd /opt
tar zxf unixodbc-2.3.0.tar.gz
cd unixodbc-2.3.0/
./configure --enable-gui=no
make && make install
时间比较长，3分钟
odbc_config --version
[root@bjdb ~]# 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
[root@bjdb ~]# cat /usr/local/etc/odbc.ini
[dm9]
driver= dm8 odbc driver
server=localhost
uid=sysdba
pwd=sysdba
tcp_port=5236
[root@bjdb ~]# cat /usr/local/etc/odbcinst.ini
[dm8 odbc driver]
driver=/home/dmdba/dmdbms/bin/libdodbc.so
[root@bjdb ~]# su - dmdba
last login: mon sep 19 07:17:14 pdt 2022 on pts/1
[dmdba@bjdb ~]$ isql dm9
---------------------------------------
| |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
---------------------------------------
sql> select instance_name,host_name from v$instance;
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| instance_name | host_name |
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| dm8 | bjdb |
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
sqlrowcount returns 1
1 rows fetched
sql> quit;
必须quit

阅读(487) | 评论(0) | 转发(0) |

上一篇：达梦temp管理

下一篇：达梦密码策略 pwd_policy

给主人留下些什么吧！~~

| | | | |

感谢所有关心和支持过chinaunix的朋友们

我的 达梦 odbc 配置-凯发app官方网站

我的达梦 odbc 配置-凯发app官方网站