[ODBC-141] Error using LOAD DATA INFILE Created: 2018-04-07  Updated: 2018-06-26  Resolved: 2018-05-16

Status: Closed
Project: MariaDB Connector/ODBC
Component/s: General
Affects Version/s: 3.0.3
Fix Version/s: 3.0.4, 2.0.17

Type: Bug Priority: Major
Reporter: Vincent Tap Assignee: Lawrin Novitsky
Resolution: Fixed Votes: 0
Labels: None
Environment:

Windows 7 32
MariaDB 10.2.14
ODBC Driver 3.0.3



 Description   

Hi,

Trying to run a "LOAD DATA INFILE" command thru ODBC and getting the following error messages :

0E68H(2) 17:45:39.996 Executing Statement 02FD7C80H:LOAD DATA INFILE 'D:/CW100_Apps/Banque/bin/../data/mouvement.csv' INTO TABLE `mabanque`.`mouvement` CHARACTER SET latin1 FIELDS TERMINATED BY ';' ENCLOSED BY '"' LINES TERMINATED BY '\n'( numero, datemvt, dateval, tiers, libelle, taux, debdev, retrait, creddev, versement, montant, horsbudget, pointage, datepoint, flag, mouvement_guid, analytique_guid, compte_guid, devise_guid, typemvt_guid, ts);
0E68H(2) 17:45:40.012 Error Occurred: S1000 [ma-3.0.3][10.2.14-MariaDB]This command is not supported in the prepared statement protocol yet

Works perfectly against a 5.7.20 MySQL database.
Works also using a JDBC client (DBVisualizer).



 Comments   
Comment by Lawrin Novitsky [ 2018-04-10 ]

Thank you for your report. We will take care of the issue

Comment by Lawrin Novitsky [ 2018-05-16 ]

The fix has been pushed into odbc-3.0 and master(0264eb0), and is yet to be merged into odbc-2.0

Generated at Thu Feb 08 03:26:31 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.