MySQL

[Dario Karlen]

Hi all

is it possible to connect from an I64 OpenVMS V8.3 to a MySQL DB (Windows) running somewhere in the LAN?? I didn't find a solution on the internet, only a mysql server for vms, no client.
Thanks.

[Hoff]

You're looking for here is an ODBC or JDBC client for OpenVMS (and not a database), and options do exist in this space.

MySQL, PostgreSQL and SQL Server can all be configured with ODBC servers.

Here's some quick background:

http://64.223.189.234/node/668

Whether or not these meet your needs or might even work in your particular environment is another discussion.

Stephen Hoffman
HoffmanLabs LLC

[Bojan Nemec · Accepted solution]

Dario,

The mysql server for VMS contains also the client part. The directory MYSQL_ROOT:[VMS.LIB] contains two libraries:


Directory SYS$COMMON:[MYSQL051.VMS.LIB]

mysqlclient_mixed.olb;1 mysqlclient_upper.olb;1


The mixed version has mixed case symbols and the upper has upper case symbols.

You can write a program which comunicate with an mysql database using one of this two libraries.

Refer to the mysql documentation for more:

http://dev.mysql.com/doc/refman/4.1/en/c-api-function-overview.html

The VMS mysql distribution can be found there:

http://www.pi-net.dyndns.org/anonymous/kits/

Bojan

[Jean-François Piéronne]

Dario,

just to mention that the preferred access page is
http://vmsmysql.dyndns.org/

This is a wiki and can freely updated.

There is also a forum which contains some informations about how to build MySQL client applications on VMS:
http://www.pi-net.dyndns.org/piforum/index.php


JF

[Dario Karlen]

Exactly what I was looking for, I found everything I need there! Thanks