Uploaded image for project: 'MariaDB Connector/ODBC'
  1. MariaDB Connector/ODBC
  2. ODBC-141

Error using LOAD DATA INFILE

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.0.3
    • Fix Version/s: 3.0.4, 2.0.17
    • Component/s: General
    • 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).

        Attachments

          Activity

            People

            Assignee:
            Lawrin Lawrin Novitsky
            Reporter:
            VT Vincent Tap
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: