topic Re: Access to PC based MySQL database from OpenVMS in Operating System - OpenVMS

Access to PC based MySQL database from OpenVMS

Brian Reiter — Thu, 14 Sep 2006 08:57:37 GMT

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

Re: Access to PC based MySQL database from OpenVMS

Martin Vorlaender — Thu, 14 Sep 2006 09:34:48 GMT

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

Re: Access to PC based MySQL database from OpenVMS

Martin Vorlaender — Thu, 14 Sep 2006 09:40:18 GMT

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

Re: Access to PC based MySQL database from OpenVMS

Hein van den Heuvel — Thu, 14 Sep 2006 10:25:29 GMT

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.

Re: Access to PC based MySQL database from OpenVMS

Jean-François Piéronne — Thu, 14 Sep 2006 12:27:43 GMT

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

Re: Access to PC based MySQL database from OpenVMS

Brian Reiter — Fri, 15 Sep 2006 02:00:35 GMT

Many thanks, hopefully should get something going today.