When MySQL ODBC queried the JSON type fields supported by the MySQL5.7 version, the error reporting program type exceeded the limit of '80004005?

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.

Menu