[Info-vax] Final Orace release on VMS.

[Arne Vajhøj]

On 11/15/2020 12:11 PM, Craig A. Berry wrote:
> On 11/15/20 10:23 AM, Marc Van Dyck wrote:
>> By the way, with the kind of Oracle licenses we have, the oracle client
>> on OpenVMS costs us nothing. It's just part of the total package.
> 
> One thing I don't think you've said is exactly how you use the client,
> though this may just be my ignorance about what "Oracle client" means to
> people who use it.  Do you have embedded SQL and are using precompilers?
> That's a pretty deep requirement that is hard to satisfy any other way.
> 
> But if you are making library calls, then in principle, calling a
> different library, or shims that sit on top of another library, could be
> possible. There are various commercial ODBC drivers, and I think at
> least some of them implement the wire-level protocol rather than relying
> on the Oracle client library underneath.  There appear to be a couple of
> open source ODBC drivers. No idea how good they are.

I believe Easysoft ODBC for Oracle use OCI.

> JDBC is hard to call from non-Java,

Yes.

But possible.

I recently discovered this little Python module:

https://pypi.org/project/JayDeBeApi/

It allows Python code executing via CPython to use JDBC drivers.
And it actually works fine.

> No personal experience, but those are the sorts of things I'd be
> exploring. We survived the demise of Sybase on VMS in 1998 by switching
> to FreeTDS clients and are still using them today.

One does what is possible.

But if there is a hard support requirement then options are
a bit restricted.

Arne