[ODBC-292] ODBC connecter 3.1.9 32 bit, can not do a LOAD DATA command. Created: 2020-09-18 Updated: 2020-09-20 |
|
| Status: | Open |
| Project: | MariaDB Connector/ODBC |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Trivial |
| Reporter: | Fred Taylor | Assignee: | Lawrin Novitsky |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Environment: |
Win 10 Pro 64 bit, latest updates, 32 bit ODBC driver 3.1.9 |
||
| Description |
|
Says load_infile disabled on the server or the client and it is on in the server. --------------------------- 1526 [MySQL][ODBC 5.3(a) Driver][mysqld-5.5.5-10.5.5-MariaDB]The used command is not allowed because the MariaDB server or client has disabled the local infile capability. The connection string is [Driver= {MariaDB ODBC 3.1 Driver};Server=datadog01;UID=root;PWD=secret;DB=test;Port=3306;option=67108864+2048;] LOAD DATA LOCAL INFILE 'C:/FBT/MPS_WORK/gp_grpsubs.csv' INTO TABLE gp_grpsubs FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES (FSUBID,FGROUPID,@FACTIVE,FSEARCHORD) SET FACTIVE=IF(@FACTIVE='T',true,false); |
| Comments |
| Comment by Fred Taylor [ 2020-09-18 ] |
|
You can forget this. Just noticed I was using the MYSQL 5.3 ODBC connector. It DOES WORK with Mariadb 3.1.9 Connector. How do I delete this issue? |
| Comment by Lawrin Novitsky [ 2020-09-20 ] |
|
As you can see from the error message, the command is disabled, and most probably on the server. You can read about it here https://mariadb.com/kb/en/load-data-infile/#load-data-local-infile |