Bug #67415 | Newest version odbc 5.2,2 fails to WRITE from Access forms to MySQL database | ||
---|---|---|---|
Submitted: | 29 Oct 2012 23:26 | Modified: | 2 Nov 2012 8:32 |
Reporter: | Jonathan Ornstein | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | Connector / ODBC | Severity: | S2 (Serious) |
Version: | 5.2(w) | OS: | Windows (7) |
Assigned to: | CPU Architecture: | Any |
[29 Oct 2012 23:26]
Jonathan Ornstein
[30 Oct 2012 15:26]
MySQL Verification Team
Thank you for the bug report. I can't repeat with Access (2007 - 2010) against a MySQL Server 5.5 and table including an INT auto_increment and timestamp columns. Please describe your environment plus the create table statement. Thanks.
[31 Oct 2012 12:15]
MySQL Verification Team
Duplicate of http://bugs.mysql.com/bug.php?id=67428 (already verified).
[2 Nov 2012 8:32]
Jonathan Ornstein
My provider, it turns out, is still running MySQL 5.0 on their servers, having delayed the previously announced upgrade to 5.5. Is this the embarassing answer to the problem? So not really a bug at all but a compatibility issue? What does then surprise me is that the OBDC connector can READ the data from the older version of MySQLwithout any problem, but cannot WRITe to an older version of MySQL. Best regards Jon