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.