Messages

1

Suggestions and Requests / Re: Export/Import Data Source Config. or connectio

« on: March 21, 2015, 01:31:07 am »

taken from the shortcut:

"EAConnectString:eadb_admin_connection --- DBType=0;ConnectEx=[...]"


The users receiving the password problem use:

Desktop: Windows 7, 64 Bit
EA (32 Bit) Version: 11.0.1106
MySQL ODBC driver (32 Bit) Version 5.1.5 (as recommended by EA)

Community MySQL Server Version: 5.6.17 (@server, 64 Bit)

As I said, no problems at all when NOT using the shortcut! Because of that, I exclude database problems (not down) or wrong driver problems.

Something doesn't work properly when using shortcut connection...

2

Suggestions and Requests / Re: Export/Import Data Source Config. or connectio

« on: March 21, 2015, 12:10:56 am »

Thanks again for your reply!

That shortcut solution currently works only for me without problems.

I have (already) added the different users using EA Security with Windows Login Authenitcation. The users also did install the MySQL ODBC driver...

Everything works fine when doing it without the shortcut. But with the shortcut, the user, even being added with EA Security, is asked to enter a password. What kind of password is that? Windows Login password doesn't work...

Can you help me again?

3

Suggestions and Requests / Re: Export/Import Data Source Config. or connectio

« on: March 20, 2015, 12:23:07 am »

Thank you, exactly what I was looking for!

So can I go further and provide that shortcut to all kind of users and make it that way easy to users to establish directly connection to data model without the need to add & create ODBC data source and data link connection manually?

The read or read/write restrictions for each user would be done then only by EA security and user management?

4

Suggestions and Requests / Export/Import Data Source Config. or connection

« on: March 19, 2015, 10:22:51 pm »

hi,

I have one MySQL database, on which I have the EA datamodel. I have only configured one admin database access, for some reasons, it is not possible to add further database users with restricted access rights.

Based on that, I want to allow read access to further EA users, but without telling them the database admin password, which is needed to build a connection to the EA datamodel I want to allow read access to (if the further users know the database password, they have the possibility to access database by any other database client if they want, this is what i want to prevent)..

So, is it possible to export either
- MySQL Connector/ODBC user data source configuration or
- Connection data link?

Or is there any other good solution on that without adding further database users and without telling the database password?

5

General Board / Re: Class diagram class attribute: list

« on: June 09, 2015, 07:01:50 pm »

Thanks! How can I model it programming language independent? How to use multiplicity and collection attribute properties correctly, if I want to transform out of the class diagram later code, e.g. to Java or even to a XSD.

Moreover: How to define an attribute to be a map, e.g.
- itemMap: Map<ClassB, ClassC>

6

General Board / Class diagram class attribute: list

« on: June 09, 2015, 05:59:07 pm »

Hello,

how can I add a list of enums or other class references as an attribute of a class? Example:

--------------
ClassA
--------------
- listofElements: List<ClassB>
--------------

Thank you for the help!

7

Bugs and Issues / MySQL ODBC - OLE DB Provider  [-2147217900]

« on: January 08, 2015, 11:49:01 pm »

Hello,

please help and support me to solve this error, while trying to use MySQL server and EA. The EA_InnoDB schema has been set successfully before (http://www.sparxsystems.com/resources/corporate/index.html#sql_scripts) and a ea data model was successfully transformed to the database.

Error:

Microsoft OLE DB Provider for ODBC Drivers [-2147217900]

[MySQL][ODBC 5.1 Driver][mysql-5.6.22-log]Your have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Partition as Signed)' at line 1


Error occurs with software:

EA (32 Bit) Version: 9.3.5, 10.x

MySQL ODBC driver (32 Bit) Version 5.1.5, 5.1.13, 5.3.4

Community MySQL Server Version: 5.6.17 (@server, 64 Bit), 5.6.22 (@local, 64 Bit)

Desktop: Windows 7, 64 Bit

 
Description:

Access to EA model without any problem, except of this:

=> Login and connection to database via EA Tool without any problem. EA model can be accessed.

=> Everytime a diagram is opened (to which access is granted), the error warning occurs.