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

ado odbc creates syntax error under win10

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 2.0.15
    • N/A
    • None
    • None
    • 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

            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.