RE: How to connect rdb Oracle 7 database under VMS using Sql*Net ?

Hi Jean,

Yes, you can use SQLNet to access the RDB databases. If you are accessing by ODBC now, then chances are you already have the "SQL Services" software installed. And you have created a service in SQLSRV_MANAGE which uses the SQL/Services protocol.

Now, to use SQLNet you have to create a service that uses the OCI protocol. Something like this -

    Owner:                    sqlsrv$deflt
    Protocol:                 OCI clients
    Default Connect Username: <not specified>
    SQL version:              STANDARD
    Autostart:                on
    Process init:             <not specified>
    Attach:                   ATTACH 'filename accounting_db'
    Schema:                   <not specified>
    Reuse:                    SESSION
    Database Authorization:   CONNECT USERNAME
    dbsrc file:               <not specified>
    SQL init file:            <not specified>
    Appl Transaction Usage:   SERIAL
    Idle User Timeout:        3600 seconds
    Idle Exec Timeout:        120 seconds
    Min Executors:            0
    Max Executors:            50
    Clients Per Executor:     1
    Active Clients:           0

Access to service FINANCE_PROD_OCI

    Granted to users:

        PRIVILEGED_USER 'SQLNET_USER' There are also scripts provided with RDB that have to be run on the RDB databases. They create the data dictionary views - DBA_USERS, DBA_TAB_PRIVS .... that Oracle is used to seeing, so that SQLnet will think its just connecting to another Oracle database. You should look at the SQL/Services administation manual and Metalink to get all the steps to running those.

Then, on the client you have to update tnsnames to add an entry for the RDB database -

ACCOUNTING_DB =
  (DESCRIPTION =
    (ADDRESS = (COMMUNITY = TCP)(PROTOCOL = TCP)(Host = Alpha)(Port = 1526))

    (CONNECT_DATA =
      (SERVICE = Accounting_DB_OCI)
    )
  )

where the service is the name of the service you created in SQLSRV_MANAGE. Note that it uses port 1526 instead of 1521 becauses RDB is using the older sqlnet version (at the least the version I'm running does).

Feel free to email me offline if you have other questions.

HTH, Beth

-----Original Message-----
Sent: Friday, August 09, 2002 9:33 AM
To: Multiple recipients of list ORACLE-L

Hello,

Currently we use ODBC drivers to establish connection between Windows clients and Rdb databases installed on VMS servers.

We have several Oracle databases under Solaris, but I don't know Oracle RDB databases under VMS ...

In this case, is it possible to user Sqlnet tools to avoid ODBC drivers
?

If it is possible, do we need to install some software on the VMS server
?

Thanks for your help and have a nice day !

Jean Berthold

--
________________________________

Jean Berthold
EOS - energie ouest suisse
Chemin de Mornex 10 , CP 570
CH-1001 Lausanne , Switzerland
Tel. : +41 (0)21 341 24 58
Fax  : +41 (0)21 341 20 49
E-Mail : jean.berthold_at_eos-gd.ch
________________________________


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jean Berthold
  INET: jean.berthold_at_eos-gd.ch

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seefelt, Beth
  INET: Beth.Seefelt_at_TetleyUSA.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).