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

ado odbc creates syntax error under win10

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Incomplete
    • Affects Version/s: 2.0.15
    • Fix Version/s: N/A
    • Component/s: None
    • Labels:
      None
    • Environment:
      Win10, MariaDB 10.2.7

      Description

      When I run a simple test script to add a record with ADO under Win10 ODBC creates the following query:
      "INSERT INTO `odbctest*`..`*myado` (`id`,`name`,`txt`,`dt`,`tm`) VALUES (?,?,?,?,?)\ 0"

      The syntax is rejected by the MariaDB server for good reasons. Surprisingly the syntax is ok under Win7.

      I add the ODBC trace for the Win10 test script.

        Attachments

        1. maodbc.dll
          1.78 MB
        2. ODBC_test.txt
          3 kB
        3. SQL.LOG
          276 kB
        4. SQL.LOG
          5.93 MB
        5. SQL.LOG
          5.93 MB
        6. SQL.LOG
          199 kB

          Activity

            People

            Assignee:
            Lawrin Lawrin Novitsky
            Reporter:
            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.