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 fbtaylor@gmail.com 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 mike@ggisoft.com 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]