Problems with FK in Data model using MySQL as repo

[mogarick]

Hi,

I'm having trouble when trying to edit or create a new FK association for my Data Model when using MySQL for storing the model repository. I'm getting the next error message:
----------------------------------------------------------
Microsoft OLE DB Provider for ODBC Drivers [-2147217900]

[MySQL][ODBC 3.51 Driver][mysql-5.0.27-community-max]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON t_object.GenType=t_datatypes.ProductName AND t_object.Object_ID=t_attribu' at line 1
-----------------------------------------------------------

After 2 identycal messages it opens the FK dialog but the involved tables attributes neither appear in the source and target area.

I hope you can help me to find a solution.

The version is 6.5.801

Greetings.

Ricardo Montoya

[peter.zrnko]

Have you seen "Create and Open Model Files Discussion"
"MySQL Limitations" in the help file?

(Justfor a case. I'm not using MySQL.)

[mogarick]

I have read it.
I have MySQL version 5 installed and my ODBC driver is 3.51 so I can't understand why it's not working.
I created the repo schema with the Innodb EA script.
When I use the EA file I don't have this problem.
Can anyone help me with these please?

I've already checked the 2 special options for the MySQL ODBC connection. (Don't optimize column width and Return matching rows)

Greetings

[hd]

This issue has been resolved for the next release.