#19 MySQL 5 FKs and SPs missing from MyMeta Browser

open
nobody
None
5
2008-01-16
2008-01-16
No

After establishing a connection to a MySQL 5.0 database, no FKs or SPs are listed in MyMeta Browser. When looping through the table's FKs in a template, nothing is generated. The template works fine in 1.2.0.7.

Discussion

  • Logged In: YES
    user_id=1317499
    Originator: YES

    FWIW, I noticed in the release notes for MySQL Connector 5.1.x, that some changes were made to the way schema metadata is reported. I remove the reference to 5.4.1.0 MySql.Data in the MyMeta solution, and added a reference to 5.0.7. After recompiling, I copied the new MyMeta.dll and the 5.0.7 version of MySql.Data.dll into the MyGeneration13 program folder.

    FKs now show up under columns in MyMeta Browser. The template which loops through a table's FKs now generates correctly. SPs still do not show in MyMeta Browser, but a template that loops through them generates correctly.

    Using the older Connector could be your quick fix, until the MySQL MyMeta code is fixed to work with the 5.1.x series.