On Tue, Mar 15, 2016 at 2:36 PM, Fred Taylor fbtaylor@gmail.com 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