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

can't read DECIMAL values : Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 3.1.19
    • 3.2.2
    • General
    • None
    • Windows

    Description

      When using ODBC Connector, values of DECIMAL types cannot be read : reading the recordset's field values causes error "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."

      Sample SQL code :

      SET @testDECIMAL := CAST(1.5 AS DECIMAL(15,2));
      SELECT @testDECIMAL;
      

      I attached a sample JSCRIPT to reproduce the bug : run it with CSCRIPT.EXE on a Windows host:

      SET MYSQL_PASSWORD=[ROOT_PASSWORD]
      CSCRIPT.EXE mariadb_decimal_odbc_bug.js
      

      It outputs the error when trying to read the @testDECIMAL variable...

      E.

      Attachments

        Activity

          People

            Lawrin Lawrin Novitsky
            edot06 Emmanuel KARTMANN
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.