MySQL Bugs: #2704: ODBC support for v4.1

Bug #2704	ODBC support for v4.1
Submitted:	11 Feb 2004 9:04	Modified:	30 May 2013 12:50
Reporter:	David Colbourn	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S3 (Non-critical)
Version:	3.51	OS:	Any (XT, AIX)
Assigned to:		CPU Architecture:	Any

Description:
The 351 driver allows me to read 4.1 tables defs but no RI defs.  I need a driver that has a feature that would allow mysql v4.1 foreign keys to be read via an odbc driver.  I didn't see it as part of the 352 build is there any Alpha or bata work being done in this area by mysql or even third parties? davidc@icarz.com

How to repeat:
Use an ODBC 351 driver to read a 4.1 mysql db (that has RI) into Erwin or some other product that reads DDL.

Suggested fix:
At rule def time write a copy to a flat file for the ODBC driver to read.  Then patch the ODBC driver to read it after all else is done.

3.51 does support SQLForeignKeys against 4.1 or later servers. If you're having difficulty with it, please provide feedback on what it is exactly that is not working, including table definitions.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Thank you for your bug report. This issue has already been fixed in the release version of that product, which you can download at

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