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

Cannot insert or update date or timestamp datatype

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.0.6, 2.0.10
    • 2.0.11
    • None
    • None
    • 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

            Lawrin Lawrin Novitsky
            sh1973 Santi H
            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.