Post by Rich Jordan
We have a number of sites using FreeTDS with our own libraries on the
VMS side to access SQL server databases. What is the best way to
programatically access MariaDB databases running on remote systems from
an OpenVMS I64 server? Is there an equivalent to the FreeTDS library
(I haven't found references that indicate MariaDB is compatible with
TDS, so presumably a different method or protocol?
Running MariaDB on the VMS system might be an option if that helps in
some manner but the live databases will remain on the remote systems.
I'm waiting confirmation but I'm pretty sure they are Linux boxes.
So you're either moving from Microsoft SQL Server over to MariaDB, or
you're adding a MariaDB database into the existing environment?
I'd probably start by looking at the connector
https://mariadb.com/kb/en/mariadb/mariadb-connector-c/ or at the
unixODBC bits: http://www.unixodbc.org — the latter has been ported to
OpenVMS, the former might or might not port. The latter was also
associated with FreeTDS builds so you may already have some of the
More (related) data...
Pure Personal Opinion | HoffmanLabs LLC