Update Web based MySQL DBMS from native Microfocus app


I'm currently using  MicroFocus VEC 5.0 in Windows 10. I've developed quite a large suite of native COBOL programs using OpenESQL to update a local installation of MS SQL server.

My question has 2 parts:

1) To switch to MySQL will I only need to change my connection string to access a 32 bit ODBC driver for MySQL instead of SQL server? I believe the SQL syntax is pretty standard so I hope my Insert, Delete and Update logic will not be affected.

1)What strategy and technology would be required to either directly update a Web based MySQL database or if that's not possible what would be another approach to upload the MySQL data in real time.

I'd like to develop a small web based application to expose this MySQL data and I don't want to use Java or COBOL.