[ODBC-71] ado .addnew function creates error Created: 2016-11-24  Updated: 2017-08-24  Resolved: 2017-02-25

Status: Closed
Project: MariaDB Connector/ODBC
Component/s: None
Affects Version/s: 2.0.13
Fix Version/s: 2.0.14, 3.0.1

Type: Bug Priority: Major
Reporter: Ph. Baumgartner Assignee: Lawrin Novitsky
Resolution: Fixed Votes: 0
Labels: None
Environment:

Win7, MariaDB 1.1.19, Office 2003, ADO, ODBC

Attachments: Text File SQL.LOG    
Issue Links:
Relates
relates to ODBC-108 ado.addnew/ODBC: Error with Decimal d... Closed

 Description   

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:
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-vb-ado.html.
The example works until the section:
'rs insert
rs.Open "select * from my_ado", conn, adOpenDynamic, adLockOptimistic
rs.AddNew
rs!Name = "Monty"
rs!txt = "Insert row"
>>rs.Update
rs.Close

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?

 Comments   
Comment by Lawrin Novitsky [ 2016-11-24 ]

Thank you for your report!
It looks like the question from here http://stackoverflow.com/questions/40723121/ado-addnew-with-odbc-for-mariadb-error, you looks like you were the one who commented there. Reporting bug was the right thing to do!

Comment by Ph. Baumgartner [ 2016-11-25 ]

Hi Novitsky
Yes, the mentioned question in stackoverflow is mine as well.

Let me know if additional info is needed.

Comment by Lawrin Novitsky [ 2017-02-25 ]

Fix and testcases have been pushed (to odbc-2.0) as rev. bf947c04146ba3df53409d430a4e91194e9de0be

Generated at Thu Feb 08 03:26:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.