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

MS Access 2016 export to odbc, mariadb 10.5.x, single/double data columns cause error: Incorrect column specifier for column

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 3.1.12
    • 3.1
    • General
    • Windows 10 1909+ 64 bit, MS Access 2016 32 bit, MariaDB ODBC driver 32 bit 3.1.12 (same with 3.1.11), Remote Mariadb 10.5.9 linux 64 bit.

    Description

      Greetings

      Exporting a table through odbc that contains single/double data type results in error "[ma-3.1.12][10.5.9-MariaDB-log]Incorrect column specifier for column 'h2'" 1063
      The SQL trace log converts for both single/double to type FLOAT(255), which mariadb does not allow insertion.
      Is there anything that I might have missed on configurations. Tried to remove strict all tables setting in mariadb but that does not help.
      My understanding is that FLOAT, FLOAT(255,0) or alike are expected by database.

      Error log attached per ODBC trace and a screenshot of simple unit test access db.

      Many thanks for any feedback.

      Attachments

        1. Table_1.PNG
          Table_1.PNG
          20 kB
        2. SQL_2.LOG
          170 kB

        Activity

          People

            Lawrin Lawrin Novitsky
            b32p0 Bekim Shala
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.