Operating System - OpenVMS
cancel
Showing results for 
Search instead for 
Did you mean: 

Access to PC based MySQL database from OpenVMS

SOLVED
Go to solution
Brian Reiter
Valued Contributor

Access to PC based MySQL database from OpenVMS

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
5 REPLIES
Martin Vorlaender
Honored Contributor

Re: Access to PC based MySQL database from OpenVMS

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
Honored Contributor
Solution

Re: Access to PC based MySQL database from OpenVMS

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
Honored Contributor

Re: Access to PC based MySQL database from OpenVMS

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
Trusted Contributor

Re: Access to PC based MySQL database from OpenVMS

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
Valued Contributor

Re: Access to PC based MySQL database from OpenVMS

Many thanks, hopefully should get something going today.