On 2016-03-15 14:36, 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.
Hi Fred!
I use MariaDB in several apps, and I use the MySQL driver, with this
connection string: DRIVER={MySQL ODBC 3.51
Driver};SERVER=server;UID=user;PWD=pwd;DATABASE=db;option=131609
Just use that one. Works great against my MariaDB/MySQL version 5+
databases.
hth,
--Mike
_______________________________________________
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/[email protected]
** 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.
