RE: Problems with MySQL Connector/ODBC 5.00.10 Beta

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

Jess Balint wrote: 
> 
> Would you mind sharing the table schema?

-- Table "contact" DDL

CREATE TABLE `contact` (
  `id` int(11) NOT NULL auto_increment,
  `language_id` int(11) NOT NULL default '0',
  `country_id` int(11) NOT NULL default '0',
  `organizer` tinyint(1) NOT NULL,
  `gender` char(1) NOT NULL default '',
  `lastname` varchar(80) default NULL,
  `firstname` varchar(80) default NULL,
  `address1` varchar(80) default NULL,
  `address2` varchar(80) default NULL,
  `city` varchar(80) default NULL,
  `province` varchar(80) default NULL,
  `postcode` varchar(20) default NULL,
  `email` varchar(80) default NULL,
  `phonehome` varchar(20) default NULL,
  `phonework` varchar(20) default NULL,
  `phonemobile` varchar(20) default NULL,
  `fax` varchar(20) default NULL,
  `remark` varchar(500) default NULL,
  `privateremark` varchar(500) default NULL,
  `birthdate` date default NULL,
  `occupation` varchar(80) default NULL,
  `reg_code_prefix` varchar(10) default NULL,
  `password` varchar(20) default NULL,
  PRIMARY KEY  (`id`),
  KEY `contact_FKIndex1` (`country_id`),
  KEY `contact_FKIndex2` (`language_id`),
  KEY `contact_lastname_index` (`lastname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


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

That is correct.

> Which 
> version of the server are you running?

5.0.19-nt-max-log

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

OK, done. Hope to send you something soon.

Paolo 



-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]