Details
-
Bug
-
Status: Open (View Workflow)
-
Trivial
-
Resolution: Unresolved
-
None
-
None
-
None
-
None
-
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.
---------------------------
Microsoft Visual FoxPro
---------------------------
LOAD DATA gp_grpsubs
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);