Connect to MySQL database from 4Dv12 or later version?

Question

Can anybody help me in connecting my MySQL database from my 4D database application. I have tried but still could not find any help. Please note that i want it without ODBC and want to directly connect to my MYSQL db.

Answer 1

I have integrated MySQL with 4D without ODBC using this C compiled library

https://www.pluggers.nl/product-category/4d-plugins/

The price is WORTH EVERY PENNY. I used both their MySQL and PostgreSQL wrappers. I talked to the developers, they have done just what you want. Provided a 4D component C library wrapper to target functionality of other databases.

It is VERY FAST.

If you decide to use the ODBC connector use this command to target a pre established ODBC connection on the machine. http://doc.4d.com/4Dv15/4D/15/SQL-LOGIN.301-2007437.en.html

Also. ignore the connectivity API is for version 2004 and is not relevant to your question.

-James