I have MyODBC 3.51 on a Windows XP box with Visio 2003.
I setup ODBC to a remote MySQL server running version 4.1.9
(tried 4.0.20, 4.0.22 and 4.0.23 as well).

The tables are InnoDB, and the foreign keys are setup properly.

When I reverse engineer a database none of the foreign keys are
reversed. I read some other posts regarding this but none of them
helped. I dont know if this is a problem with MyODBC or Visio
or what. Any feedback would be grately appreciated.

Thanks,
M

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org

Hi,

that does not work. We needed the same thing and at the end we
have written a parser of the output from SHOW CREATE TABLE statement.
Not encouraging but there is no other way. Even the InnoDB
documentation says it's the only way to figure that out.

Cheers
Radovan

On Fri, 11 Feb 2005 12:52:35 -0500, Mayuran Yogarajah
<mayuran.yogarajah [at] casalemedia.com> wrote:
> I have MyODBC 3.51 on a Windows XP box with Visio 2003.
> I setup ODBC to a remote MySQL server running version 4.1.9
> (tried 4.0.20, 4.0.22 and 4.0.23 as well).
>
> The tables are InnoDB, and the foreign keys are setup properly.
>
> When I reverse engineer a database none of the foreign keys are
> reversed. I read some other posts regarding this but none of them
> helped. I dont know if this is a problem with MyODBC or Visio
> or what. Any feedback would be grately appreciated.
>
> Thanks,
> M
>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe: http://lists.mysql.com/myodbc?unsub=Radovan.Chytracek [at] cern.c h
>
>


--
Radovan Chytracek
mailto:Radovan.Chytracek [at] cern.ch

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org