| Copyright (c) 1997 by Oracle Corporation. All Rights Reserved.
KEYWORDS: Rdb OpenVMS
TITLE: How to Access a Remote DBMS Database via the Trans. Gateway for DBMS
PRODUCT: Rdb Transparent Gateway for DBMS
OP/SYS: OpenVMS VAX V5.5 and higher
SOURCE: Oracle Worldwide Customer Support
SYMPTOM:
How can you access a remote DBMS database that exists on a remote node from
another node in the network?
RESPONSE:
You can access DBMS on a remote node through the Rdb Transparent Gateway for
DBMS in one of two ways:
ONE:
The remote database access can be handled thru the native DBMS remote access
protocol. This approach requires that DBMS be installed on both the client and
the server. The DBMS Gateway need only be installed on the client.
DBMS requires that a logical be used when BINDing to a remote database.
DEFINE REMOTE_DBMS NODE::DEV:[DIR]DBMS51.SS3
/TYPE=NSDS/PATH=REMOTE_DBMS/DICT=SYS$SHARE:DBMSQL$SHR.EXE
TWO:
If having DBMS installed on both the client and the server poses a problem,
the following method may work for you. You can also access the remote
DBMS database via SQL. This requires that the Rdb Common Components, the
DBMS Gateway and DBMS be installed on the server. The remote access is
handled at the Rdb/Dispatch level. You would need the Rdb Common Components
installed on the client as well. The attach string would look like -
SERVER_NODE::/TYPE=NSDS/PATH=DEV:[DIR]DATABASE.SSUB/DICT=DBMSQL$SHR
\
\
\ CONTRIBUTORS:
\
\ Technical: Renee Bastine
\ Editorial:
\
|