Sorry, I've got my Linux cap on :) I *think* under Windows the MySQL and MariaDB servers using an .INI file instead. It's been years since I attempted a WAMP install, so they might have moved it to the registry by now.
What I was thinking was the server and/or client is more strict than previous (or MySQL) versions that might have just ignored the _size suffix, or ignored the setting altogether. On Tue, Mar 15, 2016 at 3:06 PM, Fred Taylor <[email protected]> wrote: > Hi Ted, > > I don't seem to have a .cnf file for the server, at least none that I can > find. Where is this supposed to be? > > Also the error definitely included the "_size" portion in the error, but I > do see a "max_packet_size" in the system variables (I use Heidi-SQL) and > connect using the MySQL ODBC driver. > > Fred > > On Tue, Mar 15, 2016 at 12:01 PM, Ted Roche <[email protected]> wrote: > >> Check the my.cnf file for the server. There should be a >> max_allowed_packet (NOTE: No _size suffix!). >> >> Both server and client have this setting, and they ought to be the same. >> >> On Tue, Mar 15, 2016 at 2:56 PM, Fred Taylor <[email protected]> wrote: >> > I'm using 10.1.9-MariaDB and I am using the MySQL 5.3 driver, but I still >> > wonder why the MariaDB ODBC driver doesn't work. >> > >> > Fred >> > >> > On Tue, Mar 15, 2016 at 11:50 AM, Mike Copeland <[email protected]> >> wrote: >> > >> >> I've never used the MariaDB ODBC connector. >> >> I've always used the MYSQL ODBC 3.51 driver. Works great against both >> >> MySQL and MariaDB, all versions I've tried. >> >> Currently using MariaDB 5.5.28 >> >> >> >> Mike Copeland >> >> >> >> Fred Taylor 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). >> >>> >> >>> 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 >> >>> >> >>> >> >>> --- StripMime Report -- processed MIME parts --- >> >>> multipart/alternative >> >>> text/plain (text body -- kept) >> >>> text/html >> >>> --- >> >>> [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/CACW6n4sucJ51z6_Xo6HQYf6Z=FinQHh76TdKvT=q33bt4o6...@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.
