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/cajcbksqwa6_u355x2enwzzntpauhs1fz6od9mktxqyw05f9...@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.
