MySQL version for repository (Corp. Edition)

[danch]

Is there any version requirement for the MySQL server used as a model repository in EA Corp 4.5?

I've got MDAC 2.7update1 installed with MyODBC 3.5.1 and I've tried against MySQL 4.1.x and 3.23.xx to no avail.

with MySQL 4.1.x, I needed to doctor up my users to use the old (pre 4.1) password hash algorithm. Then I was able to upsize my model into the database, but when I try to save a diagram I get an error stating "Multi-step operation generated errors" and EA crashes.

With MySQL 3.23.xx, I'm able to upsize the model, but when opening the model get a SQL syntax error "... near 'UNION select distinct...'" MySQL Docs state that UNION was not available before MySQL 4.0.0, so this makes sense.

So, what version has Sparx Systems tested with? Does anyone have any knowledge of anything I may have done wrong in setting up version 4.1?

thanks,
Dan Christopherson

[TrtnJohn]

Here is the page you are looking for:

http://www.sparxsystems.com.au/MySQL_Instructions.htm

[danch]

Thank you! I'd seen that yesterday, but somehow missed the bit about setting the two options flags. Wasn't exactly at my best yesterday ...