If you don't get anywhere with SQL LOGIN (which should work, given the right driver settings), Pluggers Software sells the MyConnect plug-in which works perfectly and is very fast/reliable.
https://www.pluggers.nl/product/myconnect-plugin/ We've been using it for many years performing crucial functions interfacing 4D with our web stack that run 24x7x365. > On Oct 28, 2019, at 11:40 AM, Nigel Greenlee via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Should I be doing something else other that SQL > LOGIN(ODBC:xx.xx.xx.xx;username;password) for a MySQL server? ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************