I am planning to migrate applications to MariaDB with ODBC Connector. As a proof of concept I wanted to start as simple as possible. Therefore I selected the following simple ado example of the mysql developer handbook:
The example works until the section:
rs.Open "select * from my_ado", conn, adOpenDynamic, adLockOptimistic
rs!Name = "Monty"
rs!txt = "Insert row"
If I look at the ODBC Trace (see attachment), I see the following Diag:
DIAG [S1C00] [ma-1.0.6][10.1.19-MariaDB]Optional feature not implemented (0).
Could you please verify and solve this issue?