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

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 2.0.16, 3.0.3, 3.0.5
    • 3.0.6, 2.0.18
    • General
    • None
    • 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

            Lawrin Lawrin Novitsky
            adrian_sru Adrian Matlack
            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.