Minimally tested Connector/ODBC v5 through MS-Access.
Issues encountered:
1) Connecting without proper GRANT table entries yields:
"Reserved error (-7711); there is no message for this error"
instead of the proper access denied message from the server.
2) Trying to export a table containing an euro-sign fails,
Connector/ODBC chops off everything after the euro sign
from the query.
3) Trying to export a table containing data with international
character fails, Connector/ODBC chops the query short by a number
of characters equal to the number of international characters used
in a particular query.
4) Trying to export another table containing a boolean column fails,
an empty string is in the INSERT statement where the data for each
row's boolean field should be. Maybe Connector/ODBC removes
whatever MS-Access inserted there?
5) Trying to export another table containing a smallint column fails,
an empty string is in the INSERT statement where the data for each
row's smallint field should be. Maybe Connector/ODBC removes
whatever MS-Access inserted there?
6) Trying to export another table succeeds DDL-wise, but fails
when data would be inserted. The error message shown is
[MySQL][MyODBC 5.00.08] Option type out of range (#0).
7) Trying to export another table with many columns fail with
[MySQL][MyODBC 5.00.08] Driver not capable (#0).
The CREATE TABLE statement is issued, but seems to be chopped
around character 1136.
I'm starting to see the same bugs again and again now,
so I'll stop testing this until the above has been fixed.
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc [at] m.gmane.o rg
