[Info-vax] Best tools for remote MySQL access

[Rich Jordan]

We have a customer currently running their website on a wintel server/IIS with MS SQL Server backing it.  Their onsite VMS servers communicate with the webserver via the FreeTDS package via DEC BASIC, the only licensed compiler they have.

They want to move to a hosted solution for the website, and are currently evaluating Wordpress.  The backing database there is MySQL.  I did a little poking and see some DEC C-interface options that could be called from DEC BASIC, and I'm pretty sure we could use STunnel to provide the secure connection to the hosting site.  We might also consider putting Python on the VMS box to do the MySQL interfacing since it supports it pretty well.

If anyone has done similar are there specific tools or methods you would recommend for making this connection?

We have suggested, simply for ease in the conversion, that they consider a hosting service on windows with SQL server.