Access to PC based MySQL database from OpenVMS

[Brian Reiter]

Hi Folks,

Hopefully this is just a case of pointing me in the right direction.

We have a MySQL database running on a PC and some folks would like some access to it from a variety of programming languages under OpenVMS (Pascal and C mainly).

Various searches haven't been too helpful when tracking down what is needed in the way of a MySQL client.

Hope you can help

Regards


Brian

[Martin Vorlaender]

Brian,

it won't be much help for you ("Pascal and C mainly"), but Bernd Ulmann used the pure-Perl Module Net::MySQL to get data from MySQL on a Unix host to Rdb.

See http://h71000.www7.hp.com/openvms/journal/#recipes and http://search.cpan.org/~oyama/Net-MySQL-0.09/MySQL.pm

cu,
Martin

[Martin Vorlaender · Accepted solution]

Let me have another try...

In Jean-Francois Pieronne's port of MySQL server to OpenVMS Alpha I see:

Directory MYSQL_ROOT:[VMS.LIB]

mysqlclient_mixed.olb;1 mysqlclient_upper.olb;1

So it seems this contains a client library.

Download it at http://www.pi-net.dyndns.org/anonymous/kits/#mysql

cu,
Martin

[Hein van den Heuvel]

The OpenVMS Faq has some hints here.
Also, just Google: +odbc +openvms

You'll find stuff like:
http://www.odbcsdk.com/products/openrda/unix_overview.asp
"OpenRDA ODBC Driver for UNIX and OpenVMS allows applications on these platforms to access any ODBC compliant database on a Microsoft Windows "

Not saying this is a good, bad or great solution. Just a lead.
Similar products exist.

The other direction also exists, for example easysoft odbc-rms.

hth,
Hein.

[Jean-François Piéronne]

Brian,

The OpenVMS MySQL kit contains the mysql client program and as Martin wrote the necessary libraries to write C (or PASCAL) program to access a MySQL database on any system are include in the kit.

There is no MyQL client kit but you ca njust install the MySQL server kit and don't configure and start the server.

JF

[Brian Reiter]

Many thanks, hopefully should get something going today.