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:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 2d
                2d

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.