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

ODBC connecter 3.1.9 32 bit, can not do a LOAD DATA command.

    XMLWordPrintable

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);

      Attachments

        Activity

          People

            Lawrin Lawrin Novitsky
            Fred Taylor Fred Taylor
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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