MySQL - problems

[davem]

Hi,

I'm trying to evaluate the Corporate Edition (3.5).

I've create a model locally (based on the sample), added it via the data transfer facility to a MySQL (4.0.5) on linux rh7.3 using the MySQL ODBC (3.51) drivers. No problem there. Then I created a new project locally using the "connect to server" option and specifying the tables used in the previous data transfer, again no problem.

I then open a use case diagram and attempt to add objects - the problems start, for instance :

add a use case -

(EA - Message box ) An error occurred allocating a new object identifier. You may need to close allwork and repair the current project.

followed by

(EA - Message Box) There was an error creating the requested object. Please try again later.

The object then appears on the diagram, however when I come to save the diagram....

(EA - Message Box) Microsoft OLD DB Provider for ODBC Drivers (-2147467259) [tcx][MyODBC]Duplicate entry '{EDB24424-BDAB-4f91-9D98-36B536007FE4}' for key2.

followed by .....

(EA - Message Box) ADODB.Recordset{-2146825069] Operation is not allowed in the context

followed by.....

Runtime Error - program crash ! (abnormal program termination)

Looking at a previous posting I have checked the return matching Rows option in the DSN config of the MySQL ODBC Driver config.


Any help much appreciated.


Dave Milward

[James]

Hi Dave,

With my MySQL installation (4.0.4 on SuSE 8.0) I too found that I couldn't create a new DB from the EA end.  This may be because the ODBC connection is to a specific database at the server end.  If there's not one there then what do you connect to to create a new one??

One neat solution is to use Webmin to administer your server (if you don't have it then download from www.webmin.com)  You can then log on to the server from your Windows PC with the appropriate user id and create a new DB and run the scripts to create the tables.  Then copy your .EAP projects into it.  

This way also has the advantage that the MySQL user id you let the EA users have need not have all the full table create/drop permissions - you can reserve that to another MySQL user which you use for administration of the database.

Good luck

James

[davem]

James,

Thanks for replying - I have set a db on the MySQL server, using the template provided by Sparx, although having gone through everything yet again I suspect the ODBC setup. - I've noticed that when setting up the connection in Enterprise Architect I get a 'Data Link Properties' dialog box - and under connection it asks for Data source name, user name/pw followed by initial catalog.  If I enter the name of the database (e.g. nfctest) and try to test the connection I get a message box syaing 'Test connection failed because of an error in initialising provider - Catastrophic failure'.
If I don't enter anything in this box I'm ok - I can view the repository - but I still can't save an ???ything in it

Dave