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 ---
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]
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]
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]
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 tedroche@gmail.com 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 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]
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 fbtaylor@gmail.com 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 tedroche@gmail.com 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 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]
I do have several .INI file in the main folder where MariaDB is installed, but I'm not specifying any of them. Their names are: my-huge.ini my-innodb-heavy-4G.ini my-large.ini my-medium.ini my-small.ini wsrep.ini
I would guess there is a default file that is used, but those are the only .ini files I see.
In the data folder there is a my.ini file: [mysqld] datadir=C:/Program Files/MariaDB 10.1/data port=3306 sql_mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION" default_storage_engine=innodb innodb_buffer_pool_size=405M innodb_log_file_size=50M [client] port=3306
Should I add the max_allowed_packet entry to the [mysqld] section that matches the setting (419304) I see in Heidi-SQL?
Fred
On Tue, Mar 15, 2016 at 12:25 PM, Ted Roche tedroche@gmail.com wrote:
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 fbtaylor@gmail.com 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 tedroche@gmail.com 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 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]
Those INIs are suggested sets of config files, depending on what you want the machine to do.
I've never worked with Heidi-SQL, but i'd guess it was querying the server (these settings become variables you can query and sometimes change, live). I'd be more inclined to set it to 1m, based on this:
https://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_...
Obviously if you're using BLOBs or large memos, go bigger.
On Tue, Mar 15, 2016 at 3:48 PM, Fred Taylor fbtaylor@gmail.com wrote:
I do have several .INI file in the main folder where MariaDB is installed, but I'm not specifying any of them. Their names are: my-huge.ini my-innodb-heavy-4G.ini my-large.ini my-medium.ini my-small.ini wsrep.ini
I would guess there is a default file that is used, but those are the only .ini files I see.
In the data folder there is a my.ini file: [mysqld] datadir=C:/Program Files/MariaDB 10.1/data port=3306 sql_mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION" default_storage_engine=innodb innodb_buffer_pool_size=405M innodb_log_file_size=50M [client] port=3306
Should I add the max_allowed_packet entry to the [mysqld] section that matches the setting (419304) I see in Heidi-SQL?
Fred
On Tue, Mar 15, 2016 at 12:25 PM, Ted Roche tedroche@gmail.com wrote:
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 fbtaylor@gmail.com 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 tedroche@gmail.com 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 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]
I added the max_allowed_packet=1M to both the mysqld and the client sections, still same error. I did stop/start the mysql service. The change did take effect, because the setting is changed in Heidi-SQL, but the connection error still persists.
Fred
On Tue, Mar 15, 2016 at 1:41 PM, Ted Roche tedroche@gmail.com wrote:
Those INIs are suggested sets of config files, depending on what you want the machine to do.
I've never worked with Heidi-SQL, but i'd guess it was querying the server (these settings become variables you can query and sometimes change, live). I'd be more inclined to set it to 1m, based on this:
https://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_...
Obviously if you're using BLOBs or large memos, go bigger.
On Tue, Mar 15, 2016 at 3:48 PM, Fred Taylor fbtaylor@gmail.com wrote:
I do have several .INI file in the main folder where MariaDB is
installed,
but I'm not specifying any of them. Their names are: my-huge.ini my-innodb-heavy-4G.ini my-large.ini my-medium.ini my-small.ini wsrep.ini
I would guess there is a default file that is used, but those are the
only
.ini files I see.
In the data folder there is a my.ini file: [mysqld] datadir=C:/Program Files/MariaDB 10.1/data port=3306 sql_mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION" default_storage_engine=innodb innodb_buffer_pool_size=405M innodb_log_file_size=50M [client] port=3306
Should I add the max_allowed_packet entry to the [mysqld] section that matches the setting (419304) I see in Heidi-SQL?
Fred
On Tue, Mar 15, 2016 at 12:25 PM, Ted Roche tedroche@gmail.com wrote:
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 fbtaylor@gmail.com
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 tedroche@gmail.com
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 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]
On 2016-03-15 15:48, Fred Taylor wrote:
I do have several .INI file in the main folder where MariaDB is installed, but I'm not specifying any of them. Their names are: my-huge.ini my-innodb-heavy-4G.ini my-large.ini my-medium.ini my-small.ini wsrep.ini
I would guess there is a default file that is used, but those are the only .ini files I see.
In the data folder there is a my.ini file: [mysqld] datadir=C:/Program Files/MariaDB 10.1/data port=3306 sql_mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION" default_storage_engine=innodb innodb_buffer_pool_size=405M innodb_log_file_size=50M [client] port=3306
Should I add the max_allowed_packet entry to the [mysqld] section that matches the setting (419304) I see in Heidi-SQL?
I should really read all these replies before I reply. Ugh.
Are you trying to use something beyond 1024?
No, I just get an error using the MariaDB Connecter/ODBC driver. It keeps crashing out with the "max_allowed_packet_size" not found. Note that it DOES have the "_size" part in the error, but there is no system variable by that name only the "max_allowed_packet" variable which I've left as the default.
When I look in the log file, I see it's trying to set the "max_allowed_packet_size=4096" and then "Quit".
Fred
On Tue, Mar 15, 2016 at 4:58 PM, < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
On 2016-03-15 15:48, Fred Taylor wrote:
I do have several .INI file in the main folder where MariaDB is installed, but I'm not specifying any of them. Their names are: my-huge.ini my-innodb-heavy-4G.ini my-large.ini my-medium.ini my-small.ini wsrep.ini
I would guess there is a default file that is used, but those are the only .ini files I see.
In the data folder there is a my.ini file: [mysqld] datadir=C:/Program Files/MariaDB 10.1/data port=3306 sql_mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION" default_storage_engine=innodb innodb_buffer_pool_size=405M innodb_log_file_size=50M [client] port=3306
Should I add the max_allowed_packet entry to the [mysqld] section that matches the setting (419304) I see in Heidi-SQL?
I should really read all these replies before I reply. Ugh.
Are you trying to use something beyond 1024?
[excessive quoting removed by server]
Fred:
Well, it is a One-Point-Oh driver. Are you really using 1.0.0? There's an 1.0.5 release:
https://mariadb.com/kb/en/mariadb/mariadb-connector-odbc/
On Tue, Mar 15, 2016 at 8:04 PM, Fred Taylor fbtaylor@gmail.com wrote:
No, I just get an error using the MariaDB Connecter/ODBC driver. It keeps crashing out with the "max_allowed_packet_size" not found. Note that it DOES have the "_size" part in the error, but there is no system variable by that name only the "max_allowed_packet" variable which I've left as the default.
When I look in the log file, I see it's trying to set the "max_allowed_packet_size=4096" and then "Quit".
Fred
On Tue, Mar 15, 2016 at 4:58 PM, < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
On 2016-03-15 15:48, Fred Taylor wrote:
I do have several .INI file in the main folder where MariaDB is installed, but I'm not specifying any of them. Their names are: my-huge.ini my-innodb-heavy-4G.ini my-large.ini my-medium.ini my-small.ini wsrep.ini
I would guess there is a default file that is used, but those are the only .ini files I see.
In the data folder there is a my.ini file: [mysqld] datadir=C:/Program Files/MariaDB 10.1/data port=3306 sql_mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION" default_storage_engine=innodb innodb_buffer_pool_size=405M innodb_log_file_size=50M [client] port=3306
Should I add the max_allowed_packet entry to the [mysqld] section that matches the setting (419304) I see in Heidi-SQL?
I should really read all these replies before I reply. Ugh.
Are you trying to use something beyond 1024?
[excessive quoting removed by server]
On 2016-03-15 15:25, Ted Roche wrote:
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.
My.INI in the Data folder under the PF/MariaDB I believe.
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
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
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]
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]
Agreed. I see you've already got a post on the site. Let's hope they'll fix it.
You might also want to cross-post your bug report to:
https://jira.mariadb.org/secure/Dashboard.jspa
On Wed, Mar 16, 2016 at 11: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]
I'll do that. I do find it a bit hard to believe that nobody else has run across this issue before. It's really strange that the only instance that shows up in a search is the entry I just made!
Fred
On Wed, Mar 16, 2016 at 8:27 AM, Ted Roche tedroche@gmail.com wrote:
Agreed. I see you've already got a post on the site. Let's hope they'll fix it.
You might also want to cross-post your bug report to:
https://jira.mariadb.org/secure/Dashboard.jspa
On Wed, Mar 16, 2016 at 11: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]
Well, it may be that it's a thingamabob (there's a technical term for ya!) that only FoxPro trips. I remember hearing from the Fox Team on a couple of occasions that they were strict about programming exactly to the published APIs they were given, and that was why they had problems with drivers like HP printers and ATI cards, because many other devs were just passing around "code that works" while Fox devs were coding to what the docs said.
Much of the world is likely hitting that interface with DotNet, Office apps and/or 64-bit APIs that might not tweak this function.
On Wed, Mar 16, 2016 at 11:31 AM, Fred Taylor fbtaylor@gmail.com wrote:
I'll do that. I do find it a bit hard to believe that nobody else has run across this issue before. It's really strange that the only instance that shows up in a search is the entry I just made!
Fred
On Wed, Mar 16, 2016 at 8:27 AM, Ted Roche tedroche@gmail.com wrote:
Agreed. I see you've already got a post on the site. Let's hope they'll fix it.
You might also want to cross-post your bug report to:
https://jira.mariadb.org/secure/Dashboard.jspa
On Wed, Mar 16, 2016 at 11: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]
True enough, it may just be a VFP issue with the driver.
I was just trying to stay away from Oracle, in case they decide to do something later on since they now control MySQL. I'm trying to keep my options open for a move away from Windows altogether, and not get tied down to any proprietary software.
Fred
On Wed, Mar 16, 2016 at 8:41 AM, Ted Roche tedroche@gmail.com wrote:
Well, it may be that it's a thingamabob (there's a technical term for ya!) that only FoxPro trips. I remember hearing from the Fox Team on a couple of occasions that they were strict about programming exactly to the published APIs they were given, and that was why they had problems with drivers like HP printers and ATI cards, because many other devs were just passing around "code that works" while Fox devs were coding to what the docs said.
Much of the world is likely hitting that interface with DotNet, Office apps and/or 64-bit APIs that might not tweak this function.
On Wed, Mar 16, 2016 at 11:31 AM, Fred Taylor fbtaylor@gmail.com wrote:
I'll do that. I do find it a bit hard to believe that nobody else has
run
across this issue before. It's really strange that the only instance
that
shows up in a search is the entry I just made!
Fred
On Wed, Mar 16, 2016 at 8:27 AM, Ted Roche tedroche@gmail.com wrote:
Agreed. I see you've already got a post on the site. Let's hope they'll fix it.
You might also want to cross-post your bug report to:
https://jira.mariadb.org/secure/Dashboard.jspa
On Wed, Mar 16, 2016 at 11: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]
On Wed, Mar 16, 2016 at 11:50 AM, Fred Taylor fbtaylor@gmail.com wrote:
I was just trying to stay away from Oracle, in case they decide to do something later on since they now control MySQL. I'm trying to keep my options open for a move away from Windows altogether, and not get tied down to any proprietary software.
Once burned, twice shy.
It's a good idea. Since I branched out from VFP, I've learned a lot about Linux, bash, subversion and git, PHP, Python, Ruby, MySQL/MariaDB, PostgreSQL, SQLite, JavaScript, HTML5 and CSS3, vim and more. It's been a fun ride. There are a lot of cool options out there, and keeping your options open is a wise move.
(N.B., prior to VFP, I had diversified, too: Fortran, COBOL, Dynamo, SBASIC, C=64 thru Amiga, SuperBase, GEOS, CP/M and more... Freedom of Choice is one of the key freedoms of computer progress.)
The MySQL ODBC 5.3 ANSI driver works well, too.
It does appear like they consider it a serious bug, and hopefully will be dealt with soon.
Fred
On Wed, Mar 16, 2016 at 6:45 PM, < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
On 2016-03-16 11:31, Fred Taylor wrote:
I'll do that. I do find it a bit hard to believe that nobody else has run across this issue before. <snipped>
...because the MySQL ODBC 3.51 driver works great! lol
[excessive quoting removed by server]
Wonder what the advantage is of using something past 3.51?
On 2016-03-17 10:57, Fred Taylor wrote:
The MySQL ODBC 5.3 ANSI driver works well, too.
It does appear like they consider it a serious bug, and hopefully will be dealt with soon.
Fred
On Wed, Mar 16, 2016 at 6:45 PM, < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
On 2016-03-16 11:31, Fred Taylor wrote:
I'll do that. I do find it a bit hard to believe that nobody else has run across this issue before. <snipped>
...because the MySQL ODBC 3.51 driver works great! lol
[excessive quoting removed by server]
On Fri, Mar 18, 2016 at 12:18 AM, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
Wonder what the advantage is of using something past 3.51?
Improved security, SSL connectivity, bug fixes, performance improvements, the usual stuff:
https://dev.mysql.com/doc/relnotes/connector-odbc/en/
-
Fred Taylor -
mbsoftwaresolutions＠mbsoftwaresolutions.com -
Mike Copeland -
Ted Roche