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: Open (View Workflow)
    • Blocker
    • Resolution: Unresolved
    • 3.2.5, 3.2.6, 3.2.7
    • None
    • None
    • 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

        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:

              Git Integration

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