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

Process crashes when setting lc_messages (via ADODB)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 3.2.5, 3.2.6, 3.2.7
    • 3.2.8
    • General
    • MS Windows

    Description

      Create an Excel Spreadsheet and add a VBA Macro:

      Sub TestConnection()
          Dim adoConn As New ADODB.Connection
          Dim cmd As New ADODB.Command
          
          adoConn.Open "Driver=MariaDB ODBC 3.2 Driver;server=192.168.1.1;database=test;user=test;password=test"
          Set cmd.ActiveConnection = adoConn
          cmd.CommandText = "SET SESSION lc_messages = 'en_US'"
          cmd.Execute
          
          Debug.Print "done."
      End Sub
      

      Add a reference to the Microsoft ActiveX Data Objects 6.1 Library.

      As soon as you start the macro, the macro runs to the end (the done appears in the debug window) but the process crashes. The ODBC SQL.LOG shows all commands to be executed successfully.

      Same if you run the macro in an MS Access database. Same in MS Word.

      This works perfectly in all 3.1.x versions of the ODBC driver.

      Attachments

        1. SQL.LOG
          34 kB
          Walter van der Geest
        2. test_odbc_32.xlsm
          13 kB
          Walter van der Geest

        Issue Links

          Activity

            People

              Lawrin Lawrin Novitsky
              vdg@plan-bee.ch Walter van der Geest
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.