Problems with MySQL Connector/ODBC 5.00.10 Beta 2006-12-13 - By Paolo
Back
Hello!
This beta seems to be a big improvement over the previous one. I have tried
connecting to a multilingual MySQL 5 database (InnoDB) using MS Access 2003.
Firstly, Windows does not give an error when creating the data source
(bugfix as advertised).
And secondly, when looking at a linked table in Access, I now see UFT-8 (See http://UFT-8.ora-code.com) text
properly: Russian, Korean, etc., and not s string of question marks as
before.
But there are hitches:
1 - the connector sees not only the tables but also the Views in the MySQL
database. If in Access to click "Select All" to link all the tables, it
tries to link to the views as well and fails with an error ("Reserved error
(-7729); there is on message for this error.")
2 - some rows in a multilingual table, for no apparent reason have "#Error"
marked for all their values. These rows are quite usable by other programmes
(Navicat, for example).
3 - if I leave this table open in Access, then every minute or so, a pop-up
appears: "Reserved error (-7776); there is on message for this error." And
after a certain time (a few minutes), the MySQL database (also running on
Windows) crashes.
1 is just an annoyance. 2 & 3 render the connector unusable.
Paolo
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=mysql@(protected)
|
|
