oracle如何使用odbc连接dm7

小编给大家分享一下oracle如何使用odbc连接dm7，希望大家阅读完这篇文章之后都有所收获，下面让我们一起去探讨吧！上传软件包到服务器，运行以下命令：tar zxf unixODBC-2.3.0.tar.gzcd unixODBC-2.3.0./configure –with-i免费主机域名conv-char-enc=GB18030 –enable-iconv=yesmake && make installcd /usr/local/etcvim odbc.ini[DM7]Description = DM ODBC DSNDriver = DM7 ODBC DRIVERSERVER = 192.168.1.33UID = SYSDBAPWD = SYSDBATCP_PORT = 5236vim odbcinst.ini[DM7 ODBC DRIVER]Description = ODBC DRIVER FOR DM7Driver = /dmdbms/bin/libdodbc.sothreading = 0isql -v DM7 SYSDBA SYSDBAfile $ORACLE_HOME/bin/dg4odbcELF 64-bit LSB executable, x86-64cd /oracle/app/oracle/product/11.2.0/hs/adminvim initDM7.oraHS_FDS_CONNECT_INFO = DM7HS_FDS_TRACE_LEVEL = debugset ODBCINI=/usr/local/etc/odbc.iniHS_FDS_SHAREABLE_NAME = /usr/local/lib/libodbc.socd $ORACLE_HOME/network/adminvim listener.oraSID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME =
DM7) (ORACLE_HOME = /oracle/app/oracle/product/11.2.0) (PROGRAM =
dg4odbc) ) )vim tnsnames.oraDM7 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME =
DM7) ) (HS=OK) )lsnrctl statu免费主机域名ssqlplus “/as sysdba”SQL>
create public database link dmlink connect to “SYSDBA” identified by SYSDBA using ‘DM7’;SQL> select name,status$ from v$instance@dmlink;看完了这篇文章，相信你对“oracle如何使用odbc连接dm7”有了一定的了解，如果想了解更多相关知识，欢迎关注云技术行业资讯频道，感谢各位的阅读！

相关推荐: RedHat 7.7平台安装19RAC静默详细操作过程是什么

本篇内容介绍了“RedHat 7.7平台安装19RAC静默详细操作过程是什么”的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！项目RAC节点一RAC节点二主机名or…