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

ado.addnew/ODBC: Error with Decimal datatype

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 2.0.15
    • N/A
    • None
    • MariaDB 10.2.7, Win7, ADO-DB-Layer

    Description

      I am still testing the ODBC Driver for an application migration.

      When trying to add a record with integer and char datatypes, ADO performs without an error. When I add a DECIMAL datatype, ODBC raises an error:

      Valuation and B 2124-1e4c ENTER SQLGetDiagRecW
      SQLSMALLINT 3 <SQL_HANDLE_STMT>
      SQLHANDLE 0x00932AB0
      SQLSMALLINT 1
      SQLWCHAR * 0x0018D590
      SQLINTEGER * 0x0018D188
      SQLWCHAR * 0x0018D190
      SQLSMALLINT 512
      SQLSMALLINT * 0x0018D184

      Valuation and B 2124-1e4c EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
      SQLSMALLINT 3 <SQL_HANDLE_STMT>
      SQLHANDLE 0x00932AB0
      SQLSMALLINT 1
      SQLWCHAR * 0x0018D590 [ 5] "22002"
      SQLINTEGER * 0x0018D188 (0)
      SQLWCHAR * 0x0018D190 [ 71] "[ma-2.0.15][10.2.7-MariaDB]Indicator variable required but not supplied"
      SQLSMALLINT 512
      SQLSMALLINT * 0x0018D184 (71)

      Seems to me the same as the previous .addnew error.

      I will attach the ODBC Tracefile of my test.

      Attachments

        1. SQL - MySQL.LOG
          639 kB
          Ph. Baumgartner
        2. SQL - MariaDB.LOG
          159 kB
          Ph. Baumgartner
        3. SQL.LOG
          256 kB
          Ph. Baumgartner
        4. ODBC_Test_Datatypes.txt
          3 kB
          Ph. Baumgartner

        Issue Links

          Activity

            People

              Lawrin Lawrin Novitsky
              baumgaphil Ph. Baumgartner
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.