Sorry, it sent before I was done.
Not sure which driver, if any, that Heidi-SQL is using, since both the MySQL driver and the MariaDB driver are both installed. MySQL driver works, MariaDB driver does not.
Fred
On Wed, Mar 16, 2016 at 8:19 AM, Fred Taylor fbtaylor@gmail.com 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 tedroche@gmail.com wrote:
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
-- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com
[excessive quoting removed by server]