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

Error using LOAD DATA INFILE

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 3.0.3
    • 3.0.4, 2.0.17
    • General
    • None
    • 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

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.