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
          Lawrin Novitsky
        2. ODBC_test.txt
          3 kB
          Ph. Baumgartner
        3. SQL.LOG
          276 kB
          Ph. Baumgartner
        4. SQL.LOG
          5.93 MB
          Ph. Baumgartner
        5. SQL.LOG
          5.93 MB
          Ph. Baumgartner
        6. SQL.LOG
          199 kB
          Ph. Baumgartner

        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.