我的环境是oracle9.2,sql server2000,sybase11.5操作系统是windows2000
inittg4msql.ora配置如下
# This is a sample agent init file that contains the HS parameters that are
# needed for the Transparent Gateway for SQL Server#
# HS init parameters
#
HS_FDS_CONNECT_INFO="SERVER=SYBASE\TEST;DATABASE=PUBS"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
inittg4sybs.ora配置如下
# This is a sample agent init file that contains the HS parameters that are
# needed for the Transparent Gateway for Sybase#
# HS init parameters
#
HS_FDS_CONNECT_INFO=SYBASE.test
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER#
# Environment variables required for Sybase
#
set SYBASE=c:\sybase
listener.ora配置如下
# LISTENER.ORA Network Configuration File: C:\oracle\ora92\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = sybase)(PORT = 1521))
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = test)
)
(SID_DESC =
(PROGRAM = extproc)
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora92)
)
(SID_DESC =
(GLOBAL_DBNAME = tg4msql)
(PROGRAM = tg4msql)
(SID_NAME = tg4msql)
(ORACLE_HOME = C:\oracle\ora92)
)
(SID_DESC =
(GLOBAL_DBNAME = tg4sybs)
(PROGRAM = tg4sybs)
(SID_NAME = tg4sybs)
(ORACLE_HOME = C:\oracle\ora92)
)
)
tnsnames.ora配置如下
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.sybs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sybase)(PORT = 1521))
)
(CONNECT_DATA =
(SID = tg4sybs)
)
(HS = OK)
)
MSQL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sybase)(PORT = 1521))
)
(CONNECT_DATA =
(SID = tg4msql)
)
(HS = OK)
)TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sybase)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test)
)
)INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sybase)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
sqlnet.ora 配置如下
# SQLNET.ORA Network Configuration File: C:\oracle\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
通过查看试图V$PARAMETER 确定global_names为false
我是用如下语句创建database link的
create public database link msql connect to sa identified by robbie using 'MSQL';
create public database link sybs connect to sa identified by robbie using 'SYBS';
在我执行如下语句就会出错分别如下
SQL> select "a","b" from "test"@sybs;
select "a","b" from "test"@sybs
*
ERROR 位于第 1 行:
ORA-28500: 连接 ORACLE 到非 Oracle 系统时返回此信息:
[Transparent gateway for SYBASE]
ORA-02063: 紧接着2 lines(源于SYBS)
SQL> select * from "jobs"@msql;
select * from "jobs"@msql
*
ERROR 位于第 1 行:
ORA-28500: 连接 ORACLE 到非 Oracle 系统时返回此信息:
[Transparent gateway for MSSQL][Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL
Server 不存在或访问被拒绝 (SQL State: 08001; SQL Code: 17)
ORA-02063: 紧接着2 lines(源于MSQL)
我已经通过vb试过了用odbc完全可以访问sybase和sql server请问各位高手我的透明网关问题出在哪里?大家帮帮我吧,要不然春节都过不好了!
inittg4msql.ora配置如下
# This is a sample agent init file that contains the HS parameters that are
# needed for the Transparent Gateway for SQL Server#
# HS init parameters
#
HS_FDS_CONNECT_INFO="SERVER=SYBASE\TEST;DATABASE=PUBS"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
inittg4sybs.ora配置如下
# This is a sample agent init file that contains the HS parameters that are
# needed for the Transparent Gateway for Sybase#
# HS init parameters
#
HS_FDS_CONNECT_INFO=SYBASE.test
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER#
# Environment variables required for Sybase
#
set SYBASE=c:\sybase
listener.ora配置如下
# LISTENER.ORA Network Configuration File: C:\oracle\ora92\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = sybase)(PORT = 1521))
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = test)
)
(SID_DESC =
(PROGRAM = extproc)
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora92)
)
(SID_DESC =
(GLOBAL_DBNAME = tg4msql)
(PROGRAM = tg4msql)
(SID_NAME = tg4msql)
(ORACLE_HOME = C:\oracle\ora92)
)
(SID_DESC =
(GLOBAL_DBNAME = tg4sybs)
(PROGRAM = tg4sybs)
(SID_NAME = tg4sybs)
(ORACLE_HOME = C:\oracle\ora92)
)
)
tnsnames.ora配置如下
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.sybs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sybase)(PORT = 1521))
)
(CONNECT_DATA =
(SID = tg4sybs)
)
(HS = OK)
)
MSQL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sybase)(PORT = 1521))
)
(CONNECT_DATA =
(SID = tg4msql)
)
(HS = OK)
)TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sybase)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test)
)
)INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sybase)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
sqlnet.ora 配置如下
# SQLNET.ORA Network Configuration File: C:\oracle\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
通过查看试图V$PARAMETER 确定global_names为false
我是用如下语句创建database link的
create public database link msql connect to sa identified by robbie using 'MSQL';
create public database link sybs connect to sa identified by robbie using 'SYBS';
在我执行如下语句就会出错分别如下
SQL> select "a","b" from "test"@sybs;
select "a","b" from "test"@sybs
*
ERROR 位于第 1 行:
ORA-28500: 连接 ORACLE 到非 Oracle 系统时返回此信息:
[Transparent gateway for SYBASE]
ORA-02063: 紧接着2 lines(源于SYBS)
SQL> select * from "jobs"@msql;
select * from "jobs"@msql
*
ERROR 位于第 1 行:
ORA-28500: 连接 ORACLE 到非 Oracle 系统时返回此信息:
[Transparent gateway for MSSQL][Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL
Server 不存在或访问被拒绝 (SQL State: 08001; SQL Code: 17)
ORA-02063: 紧接着2 lines(源于MSQL)
我已经通过vb试过了用odbc完全可以访问sybase和sql server请问各位高手我的透明网关问题出在哪里?大家帮帮我吧,要不然春节都过不好了!
解决方案 »
- PL/SQL下为何看不到clob大对象里的数据
- oracle判断空值
- 急救!!存储过程的一个问题。
- 红帽系统下,使用oracle数据库导出命令exp遇到的问题
- !!!!!!!!!!!!!!简单问题:Oracle9i 中一个表字段原是CLOB 怎么改成VARCHAR2(8000)?
- 写触发器时如何更新其他实例的表?
- 如何在数据集中进行记录定位呢?各位帮我看看吧。
- ORACLE中的主机字符串真讨厌, 不知道干什么用的!
- proc中怎样调用存储过程
- 我装的ORACLE8的,Developer/2000 怎么没有?,
- 我在用pro*C进行多线程往一个表里插入数据时,会报ORACLE错误,据说是ORACLE需要做相关配置才能支持多线程?应该怎样配呢?
- 用 to_number(表字段名(varchar),'999999999'.99) 怎么出错??? 是不是不能对字段用to_bumber呀?急??
1、安装 Microsoft Data Access Components (MDAC)SDK ODBC driver
2、建立 SQL SERVER 数据源
test连接上我的test数据库
3、配置tnsnames.ora. (ORACLE_HOME\NETWORK\ADMIN)
test=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=tcp)
(HOST=<IP地址>)
(PORT=1521)
)
(CONNECT_DATA=
(SID=test)
)
(HS=)
)
4、配置listener.ora. (ORACLE_HOME\NETWORK\ADMIN)
(SID_DESC=
(SID_NAME=test)
(ORACLE_HOME=c:\Oracle\iSuites)
(PROGRAM=hsodbc)
)
5、重启ORACLE监听.
CMD
LSNRCTL STOP
LSNRCTL START
LSNRCTL STATUS
6、添加网关配置文件. (ORACLE_HOME\HS\ADMIN)
文件名为:inittest.ora
文件内容:
#
# HS init parameters
#
HS_FDS_CONNECT_INFO = test
HS_FDS_TRACE_LEVEL = 0
#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>
7、进入ORACLE SQL*PLUS,建立数据库链.
CREATE DATABASE LINK TOSQL USING 'test';
select * from test@hssybs
*
ERROR 位于第 1 行:
ORA-02068: 以下严重错误源于HSSYBS
ORA-28511: 丢失与使用
SID=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=sybase)(PORT=1521)))
(CONNECT_DATA=(SID=hssybs))) 的多机种远程代理程序的 RPC 连接
大家看看这个问题是怎么造成的?
我使用dsedit可应ping通sybase服务器
ORA-28500: 连接 ORACLE 到非 Oracle 系统时返回此信息:
[Transparent gateway for SYBASE]
ORA-02063: 紧接着2 lines(源于DDGLSYBS)
HS_FDS_CONNECT_INFO = alpha1000.DDGL
出现如上错误,
我刚改了成这样了:
HS_FDS_CONNECT_INFO="DBMS=SYC Adaptive Server Enterprise;ServerName=alpha1000;Database=DDGL;LogId=sa;LogPass="
纯属瞎蒙吧,结果出现和楼主同样的错误:ERROR 位于第 1 行:
ORA-02068: 以下严重错误源于DDGLSYBS
ORA-28511: 丢失与使用
SID=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.102.77)(PORT=1521)))(CONNECT_DATA=(SID=tg4sybs))) 的多机种远程代理程序的 RPC 连接
SQL> select "a","b","c" from "test"@sybs;
select "a","b","c" from "test"@sybs
*
ERROR 位于第 1 行:
ORA-01017: 无效的用户名/口令;拒绝登录
[Transparent gateway for SYBASE][A07B] Illegal username and/or password were
supplied for DS TG4SYBS
ORA-02063: 紧接着2 lines(源于SYBS)