Re: Connectivity to SQL Server from Existing COBOL Apps

Jan-Erik,
Thanks for the information. I'm a bit confused, because I hear you
saying that it's not possible, and then you describe a scenario where
you're doing it in Oracle. Is the process you describe a way to make
this happen in Oracle? And if so, can you give me a detailed account
of how you made that happen?

I really appreciate the help

Thanks,
Tracy



Jan-Erik Söderholm wrote:
Tracy skrev:
We have a set of existing COBOL apps on an OpenVMS server and would
like to know if it is possible to redirect the database calls to an
equivalent SQL Server database running on Windows. As a first step
toward porting our apps away from VMS we'd like to recreate the
database on Windows. We have already acquired the ODBC Rdb drivers and
are able to port the database metadata and data to Windows. That part
is solved. But is there a simple way to just "point" the Rdb calls to
the new SQL Server database? Thanks for your help


Some time ago, when "Microsoft SQL Server" more or less was the
same thing as "Sybase SQL Server for NT", I guess that the
"Rdb Transaparent Gateway for Sybase" could have worked.

I know of no other product that would take standard Rdb-calls
and direct them to another database product with the same ease.

At a client I've been helping with setting up "Rdb Transparent
Gateway for Oracle" running on an DS20 with VMS 8.2 and the
latest Rdb version against an AIX system with some Oracle 7 or 8
database. Using COBOL embedded SQL and the standard Rdb pre-compilers.
Completely transparent access to Oracle (both read and write)
to the code. During development/testing a real local Rdb database
is used, then with a change of a logical name, the accesses are
switched over to the Oracle database on the AIX system.

Over 10 years ago I also used the Sybase gateway, just to get a
decent interactive SQL interface instead of the lousy Sybase tools...

Jan-Erik.

.

Relevant Pages

  • Re: Why not Access...?
    ... Next, I DID NOT SAY Oracle was considered a "best choice," only a sufficient ... It is a desktop application and the database in also on the same machine. ... I also want to know why Oracle is considered a best choice as compared to SQL Server. ... > Also, you need to answer the question regarding whether or not each client> will be using an individual database, and individual copy of a central> organization database, or making straight calls to a centralized ...
    (microsoft.public.sqlserver.server)
  • Re: Merge/Replication or Syncing with Oracle
    ... You can't directly access an Access database on the desktop from a WM 5 app, but you can sync between SQL Compact on the WM device and Access using the Access Syncronizer: ... As for the Oracle issue ... ... Where SQL Compact Edition easily does merge/replication to SQL Server using IIS ... ...
    (microsoft.public.sqlserver.ce)
  • Re: Oracle vs SQL Server as a back end for Access?
    ... post -- comparing back end database engines or replacing the front end ... say that Oracle 10g is better than SQL Server 2000 without determining ... whether or not the total cost of ownership of 10g over SQL Server ... developer than Oracle 10g, in spite of its new web interface. ...
    (comp.databases.ms-access)
  • Re: Oracle licence question
    ... And no - it does not freeze anything, the backups DO NOT affect connections ... SQL Server MVP ... freeze the database and send it to the target. ... What I really wanted is something that lists features I get in Oracle ...
    (comp.databases.oracle.server)
  • 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)