Re: MySQL connection from 4D
Ive been using pluggers MyConnect for years it just works. No need to mess around with odbc. Paul -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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 **
Re: MySQL connection from 4D
Are you sure it's version 3? According to Wikipedia that version dates back to the 1990s... :) Jeff > On Oct 28, 2019, at 11:40 AM, Nigel Greenlee via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Hi > > Does anyone know if 4D is able to connect to a MySQL server running version > 3x? ** 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 **
Re: MySQL connection from 4D
The fact that it doesn’t require that you set up an ODBC Source on each machine you want to use it on is easily worth the price. Just pass it a connection string and you’re on your way. Tom Benedict > On Oct 28, 2019, at 12:49, Jim Labos - infobase via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > My suggestion is to try the demo of Pluggers myConnect plugin to try and > connect. It will at least help you find the correct syntax or protocol to > connect. > > We have been using it for years with no problem. It's one of those plugins > that is worth every penny. > > For the price it may be worth buying and stop puling your hairs out. Also > Rob is very helpful when needed. Whenever we had a problem it was always our > syntax etc. > > Worth giving it a try if only to verify if something else isn't the problem. > > Jim > ** 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 **
Re: MySQL connection from 4D
My suggestion is to try the demo of Pluggers myConnect plugin to try and connect. It will at least help you find the correct syntax or protocol to connect. We have been using it for years with no problem. It's one of those plugins that is worth every penny. For the price it may be worth buying and stop puling your hairs out. Also Rob is very helpful when needed. Whenever we had a problem it was always our syntax etc. Worth giving it a try if only to verify if something else isn't the problem. Jim - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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 **
Re: MySQL connection from 4D
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 <4d_tech@lists.4d.com> > 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 <4d_tech@lists.4d.com> >> 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 <4d_tech@lists.4d.com> >>> 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 <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 >>> ** >> >> ** >> 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 >> ** > > ** > 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 > ** ** 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 **
Re: MySQL connection from 4D
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 <4d_tech@lists.4d.com> > 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 <4d_tech@lists.4d.com> >> 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 >>> <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 >> ** > > ** > 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 > ** ** 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 **
Re: MySQL connection from 4D
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 <4d_tech@lists.4d.com> > 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 >> <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 > ** ** 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 **
Re: MySQL connection from 4D
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 **
MySQL connection from 4D
Hi I am pretty sure other people are connecting to MySQL from 4D so i am hoping someone can advise me on where my problems may lie. Pre-amble:— I want to connect to the database of an Asterisk Telephone server. We have established that the database is accessible on the network and using ‘sequel-pro’ i can connect from my Mac(Seqel-pro bypasses ODBC manager so its not that helpful in diagnosing my problem). I have also been able to setup and test an ODBC connection using the ODBC manager on WIndows, as i was not having much luck getting a connection from 4D to the MySQL database on my mac i switched my efforts to there. After some flapping around I established that the my-sql connector we had did not match the my-sql server which is running 3.5x. Later drivers on the pc would not connect but the 3.5 driver does connect to the MySQL database From Windows(as you know the odbc administrator on PC The problem in a nutshel:— However when i try to get my 4D app to to perform a login i get a stack overflow problem from 4D V17.(recursive errors eventually returning control to me!). Does anyone know if 4D is able to connect to a MySQL server running version 3x? Should I be doing something else other that SQL LOGIN(ODBC:xx.xx.xx.xx;username;password) for a MySQL server? Nigel Greenlee ** 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 **
