One other bit of info is that the mySQL database I’m connecting to is version 8.0.17. Sorry I don’t have any experience with version 3.x.
Tom Benedict > On Oct 28, 2019, at 09:11, Tom Benedict via 4D_Tech <[email protected]> > wrote: > > 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] > ********************************************************************** ********************************************************************** 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] **********************************************************************
