True enough, it may just be a VFP issue with the driver. I was just trying to stay away from Oracle, in case they decide to do something later on since they now control MySQL. I'm trying to keep my options open for a move away from Windows altogether, and not get tied down to any proprietary software.
Fred On Wed, Mar 16, 2016 at 8:41 AM, Ted Roche <[email protected]> wrote: > Well, it may be that it's a thingamabob (there's a technical term for > ya!) that only FoxPro trips. I remember hearing from the Fox Team on a > couple of occasions that they were strict about programming exactly to > the published APIs they were given, and that was why they had problems > with drivers like HP printers and ATI cards, because many other devs > were just passing around "code that works" while Fox devs were coding > to what the docs said. > > Much of the world is likely hitting that interface with DotNet, Office > apps and/or 64-bit APIs that might not tweak this function. > > > On Wed, Mar 16, 2016 at 11:31 AM, Fred Taylor <[email protected]> wrote: > > I'll do that. I do find it a bit hard to believe that nobody else has > run > > across this issue before. It's really strange that the only instance > that > > shows up in a search is the entry I just made! > > > > Fred > > > > On Wed, Mar 16, 2016 at 8:27 AM, Ted Roche <[email protected]> wrote: > > > >> Agreed. I see you've already got a post on the site. Let's hope they'll > >> fix it. > >> > >> You might also want to cross-post your bug report to: > >> > >> https://jira.mariadb.org/secure/Dashboard.jspa > >> > >> On Wed, Mar 16, 2016 at 11:19 AM, Fred Taylor <[email protected]> > wrote: > >> > Heidi-SQL connects when I just give it the IP address and the port, so > >> I'm > >> > not sure if it uses the MariaDB ODBC driver or not, or if it's just > using > >> > > >> > In any case,I searched for the string "max_allowed_packet_size" and it > >> > shows up in the debug symbols for the ODBC driver itself. Checking > the > >> log > >> > file, it shows an attempt to set that variable to 4096, and then the > next > >> > entry is "Quit". > >> > > >> > Sounds more like a driver issue to me. > >> > > >> > Fred > >> > > >> > On Wed, Mar 16, 2016 at 6:35 AM, Ted Roche <[email protected]> > wrote: > >> > > >> >> On Tue, Mar 15, 2016 at 2:36 PM, Fred Taylor <[email protected]> > >> wrote: > >> >> > Anybody familiar with the MariaDB ODBC Connector for Windows? I > >> can't > >> >> get > >> >> > connected using it as I get an "Connectivity Error: Unknown system > >> >> variable > >> >> > 'max_allowed_packet_size'". This is the 32 bit driver on a Win7 > 32bit > >> >> > machine. when using SQLSTRINGCONNECT("Driver={MariaDB ODBC 1.0 > >> >> > Driver};Server=localhost;UID=myuser;PWD=mypwd;DB=test;Port=3306;") > >> >> > > >> >> > I can create a DSN and it says it connects in the Test mode, but I > >> can't > >> >> > connect using that DSN (same error as above). > >> >> > >> >> Does the Heidi-SQL tool use DSNs to connect, and if so, can it > connect > >> >> to the server using the DSN you created? If it can and VFP can't, > that > >> >> points to VFP. > >> >> > >> >> > I've googled for this error and literally nothing of pertinence > shows > >> up. > >> >> > > >> >> > I can get the MySQL ODBC 5.3 driver to work, but no luck with the > >> MariaDB > >> >> > Connector. > >> >> > > >> >> > Fred > >> >> > >> >> -- > >> >> Ted Roche > >> >> Ted Roche & Associates, LLC > >> >> http://www.tedroche.com > >> >> [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJCBkspe7a8JywNDtJcmeTTBke_iBO=VqyshOUp+A7R71Mgj=a...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
