Re: RDB v?: ODBC???

From: JustMe (mc.moore_at_sympatico.ca)
Date: 05/21/03


Date: Tue, 20 May 2003 20:09:07 -0400

Might want to try the procedure $@sys$library:RDB$SHOVER first.

Depending on version, it might be called DECRDB$SHOVER.com (old) or even
RDBVMS_SHOVER.com (older)

There is also an SQL$SHOVER.com procedure for that component

CM

"Ron Milen" <milenronald@mailbag.net> wrote in message
news:3eca9568_3@newsfeed...

"j.lance wilkinson, (814) 865-1818" <jlw@psulias.psu.edu> wrote in message
news:baduii$12lq$1@f04n12.cac.psu.edu...
> We have RDB running on our OpenVMS v7.2-1h1 system. Nobody seems to
> know what release of RDB we've got, but there are manuals for v7.0
> present so it ought to be at least that level.
>
> 1) HOW do I determine from the existing installation which release
> it is?
>

Use the command $RMU/SHOW VERSION database_root_filename

> 2) DOES any given release of RDB have ODBC interfaces available,
> such that I can allow authorized users to access the database
> from an ODBC-compliant program, like MS-Access? If only certain
> releases, which ones?
>
Yes, here's the documentation from Oracle which can be found at
http://otn.oracle.com/products/rdb/htdocs/rdb_odbc/content.html.

      Oracle ODBC Driver for Rdb v3.0.2.6

      The Oracle ODBC Driver for Rdb enables Microsoft[R] Windows, Windows
95[R], Windows NT[R] and Windows XP[R] applications that implement the
Microsoft Open Database Connectivity (ODBC) API to read from and write to
Oracle Rdb databases and database accessible through the Oracle DB
Integrator family of gateways.

      The Oracle ODBC Driver for Rdb distribution kit includes all of the
database client software required to allow an ODBC-enabled application to
access Oracle Rdb. The kit consists of Dynamic Link Libraries, a Windows
help file, a copy of the license and this product description. In addition
to the ODBC-enabled application and the Oracle ODBC Driver for Rdb, a
network transport is required on the client.

      This product is installed by the Oracle Universal Installer, a
completely different technology from that used by previous releases of the
Oracle ODBC Driver for RDB.

      To assist those customers who do not already have the Universal
Installer, this kit is being made available in two forms, one without the
installer included (about 1 MB in size) and one with the installer (about 12
MB in size). Both kits are distributed on the web in the form of
self-extracting ZIP archives.

      Click here to download the Oracle Rdb ODBC kit

> 3) Where on my system should I find documentation for accomplishing this?
>
Oracle RDB documentation can be found at:
 http://otn.oracle.com/docs/products/rdb/content.html

Good Luck!
Ron Milen
Milen Consulting Services



Relevant Pages

  • Re: Oracle RDB on VAX/Open MVS
    ... We had to migrate AARPs Rdb database to Oracle awhile back. ... PC style hardware, but it is only out as an evaluation right now. ...
    (comp.os.vms)
  • Re: Rdb, standard vs. multiversion and link problems
    ... oracle Rdb support directly and have them help get you a standard ... MANMAN V11.4 usage and are part of the same Oracle media kit. ... Apparently the Rdb V7.1 kits are all "Multiversion", ... fall back to V7.0 to get a standard single version kit. ...
    (comp.os.vms)
  • Re: Rdb, standard vs. multiversion and link problems
    ... oracle Rdb support directly and have them help get you a standard ... MANMAN V11.4 usage and are part of the same Oracle media kit. ... Apparently the Rdb V7.1 kits are all "Multiversion", ... fall back to V7.0 to get a standard single version kit. ...
    (comp.os.vms)
  • Re: Connectivity to SQL Server from Existing COBOL Apps
    ... you're doing it in Oracle. ... equivalent SQL Server database running on Windows. ... But is there a simple way to just "point" the Rdb calls to ...
    (comp.os.vms)
  • Re: Oracle statement of direction
    ... Oracle Rdb and Oracle Database on OpenVMS are developed by two ... the port of Rdb to Itanium is well underway. ... both database and applications will run entirely ...
    (comp.os.vms)