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

Cannot insert or update date or timestamp datatype

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.0.6, 2.0.10
    • Fix Version/s: 2.0.11
    • Component/s: None
    • Labels:
      None
    • Environment:
      Windows 8 64bit, Ms Access 2013, Ubuntu-Mariadb 10.1.13, Connector 2.0.10

      Description

      Created a table in Mariadb 10.1.13 which has a date field on Ubuntu 14.04.
      Created a linked table in MSAccess 2013 pointing to it.
      When trying to save a record and specifying a date like 2014-01-01 I get an ODBC error saying that there was an overflow of the interval for a data type (message is in spanish).
      Record does not get saved.
      If the record already exists (like created manually in the MariaDB console) the date gets correctly loaded into the MSAccess table. However, no updates, nor even delete operations can be carried out on that record, throwing always the same error message.
      When I downgraded to the 1.0.6 version of the connector, everything was GO again.

        Attachments

          Activity

            People

            Assignee:
            Lawrin Lawrin Novitsky
            Reporter:
            sh1973 Santi H
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration