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

Wrong Query Send by ODBC Driver 03.01.10.00

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 3.1.11
    • Fix Version/s: 3.1
    • Component/s: General
    • Labels:
    • Environment:
      Win x64 Access 2016

      Description

      Hi,

      I debugged the query which is send via ODBC Driver 03.01.10.00 (Access 2016 application) to my MariaDB 10.5 on FreeBSD.

      On every field which is TIMESTAMP or DATETIME or DATE, the ODBC Query is like

       

      Execute UPDATE `tblBaustellenDaten` SET `Arbeitsbeginn`=TIMESTAMP'2021-01-26 10:00:00' WHERE `BaustellenDaten_ID` = 13010 AND `Stempel` = TIMESTAMP'2021-01-26 17:25:27'

      The leading 'TIMESTAMP' creates fails on INSERT / UPDATING, of course, the server expects a Date and not the string 'TIMESTAMP' and the date.

      I just installed the latest mysql odbc connector and it works flawless.

        Attachments

          Activity

            People

            Assignee:
            Lawrin Lawrin Novitsky
            Reporter:
            hevilp Piet
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration