EA MySql integration driver issue

[seritalien]

Hello everybody,

I just finishing to configure EA to use Mysql at a back end.
Everything looks good besides everytime i load a diagram, i got the error you can see in this picture http://imageshack.com/scaled/800x600/855/icr6.jpg

Besides that, i can access all of my diagrams and work with. but that is really anoying.

My setup :
EA 8
Mysql 5.6
Mysql Connector ODBC 5.2
2 Windows remote machines

any hint would be appreciate.

thanks
seritalien

[qwerty]

Check this post: http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1370293118/3#3
and the driver you are using.

q.

[Eve]

I'm afraid the answer is simpler than that.

MySQL 5.6 introduced a new keyword and won't work for any version of EA prior to 10 (in fact build 1009 which is the latest)

[seritalien]

Alright,

thanks for the answer, as i, unfortunatly can't change my version of EA, i have to downgrade Mysql.

[seritalien]

hi again,

could you please say me which mysql server / driver is compatible with my EA version 8.0.864 ?

thanks you !
seritalien

[qwerty]

See the link in my above post. Works also for older EA versions.

q.

[seritalien]

thanks Q. for you reply,

but i cant find where to find the information i need, in the link you gave me above.
For instance, i'd like to find which Mysql version suits ok with my EA Version
seritalien

[RoyC]

The Help for your version of EA should tell you that - look at the Projects and Teams > Server Based Repositories section.

I have looked at a copy of the Help from (I think) EA build 864, and it recommends using MySQL 4.0.3 or higher (up to 5.0), with the MySQL ODBC 3.51 (or up to 5.1.5, but NOT 3.51.14) driver.

Check the Help integrated with your installation of EA, to be on the safe side.

[seritalien]

thanks to all of you,
i tested with MySQL 5.5.34 and connector/ODBC 5.2.
and eveything works well.

cheers
seritalien