The only thing I can add is to make sure your ODBC Driver, ODBC Data Source Administrator and 4D all match with respect to 32bit or 64 bit.
I am connecting to a mySQL DB using 4D Native (SQL LOGIN) via mySQL ODBC 8.0 Unicode Driver and 4D v17R4. All 64 bit. HTH, Tom Benedict > On Oct 28, 2019, at 09:00, Nigel Greenlee via 4D_Tech <[email protected]> > wrote: > > Jeff > > Indeed i did look at that(-its overkill for what i need) but it does say on > there it works for Mysql V4 and up-hence why i am wondering of 4D in itself > won’t connect to and older version. > > Thanks > > Nigel > >> On 28 Oct 2019, at 15:54, Jeffrey Kain via 4D_Tech <[email protected]> >> wrote: >> >> 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 >>> <[email protected]> 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:[email protected] >> ********************************************************************** > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
