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

DATE and DATETIME values are NULL in Crystal Reports

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.16, 3.0.3, 3.0.5
    • Fix Version/s: 3.0.6, 2.0.18
    • Component/s: General
    • Labels:
      None
    • Environment:
      Windows 10

      Description

      I am attempting to use the MariaDB ODBC connector as a replacement for the MyODBC connector and have run into an issue where all DATE and DATETIME fields are being read by the report as having NULL values.

      I found the following reference to this issue here: https://apps.support.sap.com/sap/support/knowledge/public/en/2604895

      That page describes a workaround (one that would not be practical in my situation) but for the cause says only "MariaDB is not listed in the supported data sources for Crystal Reports". In my case I am using the MariaDB ODBC connector to connect to a MySQL 5.0 database, so something must be different in how the results appear to the report.

      I would be happy to provide any additional information in tracking down the difference that is causing the conflict.

        Attachments

          Activity

            People

            Assignee:
            Lawrin Lawrin Novitsky
            Reporter:
            adrian_sru Adrian Matlack
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: