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.