[Info-vax] Best tools for remote MySQL access

[Jeffrey H. Coffield]

On 03/25/2021 08:06 AM, Rich Jordan wrote:
> 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.
>

We have implemented several different solutions to sync data on OpenVMS 
with MySQL servers and the best solution depends on exactly what data 
they need to export. Data in RMS files is one thing, but data derived 
using existing business logic is different.

It you would like to discuss your requirements in greater detail, please 
either email me at jeffrey at digitalsynergyinc.com or give me a call at 
1-949-650-0526.

Jeff Coffield
www.digitalsynergyinc.com