[Info-vax] VSI working on alternatives to Oracle Classic database
Jan-Erik Söderholm
jan-erik.soderholm at telia.com
Wed Jan 20 17:46:03 EST 2021
Den 2021-01-20 kl. 21:44, skrev Craig A. Berry:
> On 1/20/21 2:30 PM, Arne Vajhøj wrote:
>> On 1/20/2021 2:51 PM, Craig A. Berry wrote:
>>> On 1/20/21 11:11 AM, Dave Froble wrote:
>>>> What I found interesting is the SQL Relay software. Without knowing
>>>> much about it, it still seems to be a solution, for those willing to
>>>> use third party software.
>>>
>>> It's a library that speaks its own network protocol to a remote proxy
>>> agent that in turn talks to the remote database. It might not have been
>>> that hard to port the client. For people already calling a C API or
>>> something built on one, it could be a solution that is not too painful.
>>> But for people using a SQL precompiler for one of the traditional
>>> languages, there's a lot of pain headed their way.
>>
>> So it would be:
>>
>> app VMS
>> SQL Relay client
>> |
>> (SQL Relay protocol) -----
>> |
>> SQL Relay proxy Linux
>> Oracle client
>> |
>> (Oracle protocol) -----
>> |
>> Oracle DB Linux
>>
>> ?
>
> That is my understanding. Read all about it here:
>
> <http://sqlrelay.sourceforge.net>
>
>
>
Very much like the "Rdb Transparent Gateway to ODBC data" that is
(was) part of the "Database Integration" (DBI) kit, that is still
available unsupported from Oracle for Alpha.
That gateway (that had a standard Rdb SQL interface so it could
be called from any VMS language using the Rdb SQL precompiler, the
application did not now it was not accessing a real Rdb database)
connected to a Windows box where you can access any database (or
"data source") that had a ODBC driver.
More information about the Info-vax
mailing list