Connecting Progress to MySQL database

[shafee212]

Hi , Can I connect progress to MYSQL database ??


If so , then How to do it . The main purpose of this is to make some interfaces in Progress 4 gl and connect it to some existing MYSQL tables .

Thanks in advane .

 

[MaximMonin]

Data Administration -> Data Server -> ODBC Utilities -> Create Data Server schema.

You create Progress DB which contains Schema Holder for your MY SQL DB. Schema Holder = tables description + connection string to external DB.
After this step you work with this DB just like ordinary progress DB. (Connect/find/for each etc). All data will be written to MY SQL DB through Schema Holder Interface.