配置透明网关的步骤

BruDog

支持一下

j2ee

http://www.ncn.cn/download/dindex.htm

13950211081

SQL>
SQL> Select * From cat
  2  /

TABLE_NAME                     TABLE_TYPE
------------------------------ -----------

SQL> select * from ADSL@db_sq_112;

select * from ADSL@db_sq_112

ORA-28500: 连接 ORACLE 到非 Oracle 系统时返回此信息:
[Transparent gateway for MSSQL]
ORA-02063: 紧接着2 lines（源于DB_SQ_112）

SQL>

13950211081

initcdmarket112.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=192.168.23.182,5678;DATABASE=market"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER

tnsnames.ora

SQ112 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = cap-webserver)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = cdmarket112)
    )
    (HS=OK)
  )

listener.ora

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = capface)
      (ORACLE_HOME = C:\oracle\ora92)
      (SID_NAME = capface)
    )
    (SID_DESC =
      (PROGRAM = extproc)
      (ORACLE_HOME = C:\oracle\ora92)
      (SID_NAME = PLSExtProc)
    )
    (SID_DESC =
      (SID_NAME = cdtest97)
      (ORACLE_HOME = C:\oracle\ora92)
      (PROGRAM = tg4sybs)
    )
    (SID_DESC =
      (SID_NAME = cdmarket112)
      (ORACLE_HOME = C:\oracle\ora92)
      (PROGRAM = tg4msql)
    )

  )

pineapplecui

顶一下

mikesonic

我们在好几台win2000 adv sp4机器上都安装过oracle9iR2的针对sybase的透明网关，但是好像P4的机器从来没有成功过.也出现了类似楼上13950211081
的问题
sybase客户端安装的是11.92
有人知道怎么解决吗？

icerain0322

9i中有该组件，在８ｉ中好像没有啊！！哪里有下载啊！！

bloomit

最初由 icerain0322 发布
[B]9i中有该组件，在８ｉ中好像没有啊！！哪里有下载啊！！ [/B]

In 8i(8.1.5 - 8.1.7) [B]for windows[/B], there do exist transparent gateway component. But it's not installed defaultly, pay attention to this during installation...

icerain0322

在自定义安装里也没有找到啊！！！

zgx_290

oracle9i和db2能用transjparent gateway 吗？