Bug #23549 Reserved error (-7749) for Access connection trough MyODBC 5
Submitted: 23 Oct 2006 10:22 Modified: 23 Nov 2006 10:15
Reporter: Georg Klaissner Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S2 (Serious)
Version:5.00.05.00 OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[23 Oct 2006 10:22] Georg Klaissner 
Description:
Similar to bug #15784 with the Alpha Version, the 5.0.5 Beta now creates the error message "Reserved error (-7749). Description of this error is absent." when trying to link to a table.

This happened on 2 different Win-XP PC's, one had the Alpha 5.0.0 installed before, the other didnt.

How to repeat:
Create DSN for MyODBC 5 and try to use this DSN to link from MS Access 2003 to any table in MySQL
[23 Oct 2006 11:41] Tonci Grgin 
Hi Georg and thanks for your problem report. I am aware of this problem. It seems to happen if:
  Table has PK/Unique Key
  First column in table is of INT type
[2 Nov 2006 10:52] Ben Wilder 
Hi there, I too am experiencing this bug:

server version: 5.0.24-community-nt
Xp version: XP home SP2 
ODBC Version : 5.00.05.00

Linking tables to Access 2003 causes error "Reserved Error (-7749)"

the only table to successfully link was the only table that does not have a primary key.

Hope this helps.
[23 Nov 2006 10:15] Tonci Grgin 
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/

Explanation: Although some problems remain, this is fixed in 5.00.09