topic MySQL in Operating System - OpenVMS

MySQL

Dario Karlen — Wed, 12 Mar 2008 12:16:48 GMT

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.

Re: MySQL

Hoff — Wed, 12 Mar 2008 14:49:58 GMT

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

Re: MySQL

Bojan Nemec — Wed, 12 Mar 2008 16:53:21 GMT

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

Re: MySQL

Jean-François Piéronne — Thu, 13 Mar 2008 06:24:05 GMT

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

Re: MySQL

Dario Karlen — Thu, 13 Mar 2008 10:33:26 GMT

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