Re: Problems with MySQL Connector/ODBC 5.00.10 Beta

On Wed, Dec 13, 2006 at 03:40:00PM +0100, Paolo wrote:
> 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.")

Linking views is allowed just the same as tables.

> 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).

Would you mind sharing the table schema?

> 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.

So you are saying the database server also crashes, and you cannot
reconnect until you restart the database server? Which version of the
server are you running?

Can you create an ODBC trace log for all three of these issues? This can
be enabled in the ODBC data source administrator applet.

Thanks.
Jess


-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@xxxxxxxxxxx