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

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 3.1.11
    • 3.1
    • General
    • 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

            Lawrin Lawrin Novitsky
            hevilp Piet
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.