Highlighted
Regular Contributor.
Regular Contributor.
163 views

Update Web based MySQL DBMS from native Microfocus app

Hi

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.

Thanks

Elliot

0 Likes
4 Replies
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: Update Web based MySQL DBMS from native Microfocus app

OpenESQL is meant to be database vendor agnostic so that the same programs will run against a different database vendor simply by switching the ODBC driver as you indicate here. As long as you are not using any syntax that is supported only by SQL Server then it should run OK against MySQL as well.

I am not really sure what you are looking for in your second question. Using ODBC you could access the database on the web server directly if you had permissions and a connection to it but that kind of defeats the purpose of having a web server.

Is it that you are just trying to keep a local MySQL database and a server MySQL database in sync with each other?

0 Likes
Highlighted
Regular Contributor.
Regular Contributor.

Re: Update Web based MySQL DBMS from native Microfocus app

Hi Chris

"keep a local MySQL database and a server MySQL database in sync with each other"

yes - exactly.

0 Likes
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: Update Web based MySQL DBMS from native Microfocus app

A quick Google search yielded quite a few results including the use of MySQL Replication services.

See the link here:

 

 

0 Likes
Highlighted
Regular Contributor.
Regular Contributor.

Re: Update Web based MySQL DBMS from native Microfocus app

Thanks so much for the help Chris. This thread can be marked as solved.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.