关于ORACLE访问SQLSERVER的问题 在ORACLE中尝试连接SQLSERVER,用了两种方法 : ODBC(PROGRAM=hsodbc) 和 透明网关(PROGRAM=tg4msql)但用TNSPING 后都提示无监听器。另外问下PROGRAM这个参数的具体含义,谢谢。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 PROGRAM是告诉Oracle连接哪种异构数据库。你的问题估计还是配置的问题。 PROGRAM=tg4msql 是固定的写法。 tg4msql标识指向sql server.例子:tnsnames.oraSQL2K = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = tg4msql) ) (HS = OK) )#LISTENER.ORA Network Configuration File: C:\database\oracle\NETWORK\ADMIN\listener.ora# Generated by Oracle configuration tools.LISTENER = (ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)) (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (SID_NAME=tg4msql) (ORACLE_HOME=c:\database\oracle) (PROGRAM=tg4msql) ) )create database link tosql2k connect to sa identified by sa using 'sql2k';参考:1、Oracle9i Heterogeneous Connectivity Administrator's Guide PROGRAM=tg4msql 是固定的写法。 tg4msql标识指向sql server. 例子: tnsnames.ora SQL2K = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = tg4msql) ) (HS = OK) ) #LISTENER.ORA Network Configuration File: C:\database\oracle\NETWORK\ADMIN\listener.ora # Generated by Oracle configuration tools. LISTENER = (ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)) (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))) SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (SID_NAME=tg4msql) (ORACLE_HOME=c:\database\oracle) (PROGRAM=tg4msql) ) ) create database link tosql2k connect to sa identified by sa using 'sql2k'; 批量更新数据方法 多表问题 高分请教索引失效问题 关于百分数的小数位问题 oracle中,设定varchar2长度为4000,为什么存到980就不行了??? 如何知道某个表的partition_name? [SQL]Date数据怎么在SQL语句中写?(Error ORA-01861 文字与格式字符串不匹配) 有关谢卸栽的问题(在线等) 答题奖励30分 PLSQL Developer启动问题报错。ora-12560:tns:协议适配器错误 急急急...请教一PL-SQL语句 数据库的题
你的问题估计还是配置的问题。
tnsnames.oraSQL2K =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = tg4msql)
)
(HS = OK)
)
#LISTENER.ORA Network Configuration File: C:\database\oracle\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=tg4msql)
(ORACLE_HOME=c:\database\oracle)
(PROGRAM=tg4msql)
)
)
create database link tosql2k connect to sa identified by sa using 'sql2k';
参考:
1、Oracle9i Heterogeneous Connectivity Administrator's Guide
tnsnames.ora SQL2K =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = tg4msql)
)
(HS = OK)
)
#LISTENER.ORA Network Configuration File: C:\database\oracle\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools. LISTENER =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))) SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=tg4msql)
(ORACLE_HOME=c:\database\oracle)
(PROGRAM=tg4msql)
)
)
create database link tosql2k connect to sa identified by sa using 'sql2k';