problem description
MySQL 5.7.35 database has a table test, in which there is a field content which is of JSON type and contains data in JSON format
the server is Windows Serer 2012 with MySQL Connector ODBC version 5.3 installed
query the JSON field with the following statement Times error
Set RS = Conn.Execute("SELECT content FROM test LIMIT 1")
If RS.EOF Then "
End If
Microsoft OLE DB Provider for ODBC Drivers error "80004005"
Microsoft program type is out of bounds
the environmental background of the problems and what methods you have tried
an error will be reported as long as the query statement field contains a field of type JSON.
upgrading MySQL Connector ODBC to version 8.0 remains the same;
changing the content field type in the table to a non-json type, such as longtext, will not report an error and can be queried normally.
related codes
/ / Please paste the code text below (do not replace the code with pictures)
what result do you expect? What is the error message actually seen?
under the premise that the field type is JSON, is there any other solution.