Cloud service. How does it work

[Onno2]

I am reading through the Cloud Services PDF while trying to configure it locally. I can't get it to work.

System output always shows the same message when I try to connect
Cloud Services: The database manager for this database was shutdown

The PDF does not explain very well how the client should be configured. Specifically I can add a Database Manager succesfully using the management client but it is unclear how EA connection should be created to get access. It expects a Model Name. What name is this?

When I add a random thing it shows the message
Cloud Services: Server Error - There is no database manager configured for the requested repository

When I copy the name that EA creates (complicated) for example msdasql.1:[email protected] it shows the message
Cloud Sercvies: The database manager for this database was shutdown

What does this message mean? How can I start and shutdown databases?

[philchudley]

The name of the database in the connect dialog is the actual name of the database in your dmbs

[Eve]

Cloud Services: The database manager for this database was shutdown

If you're getting that message then you have the correct name, but you need to enable the connection.

Select the connection in the list of database managers.
Click Configure
Click Accept Queries.
Click Save
Try connect again.

[Onno2]

Thanks, I think the model name is correct now. Now I have a different message
Cloud Services: Unable to connect to database      


I have a local mysql db on 3306 which I can connect to using ordinary DBMS connect.

When using cloud client I can reuse that datasource, create a connection, test it. Test succeeds but when I use the cloud connect message is unable to connect to database.

[Onno2]

The message unable to connect to database is the same message I see if I shutdown the database.

Is it possible that this is a 64bit 23bit issue. EA is a 32bit application and I had to use a 32bit driver to connect. Maybe the Cloud Service requires a 32bit OS?

[Onno2]

I was thinking about a second attempt. Now using a Oracle database. From the screenshots I think I can see this is also a 32bit Oracle client that was installed. Now this is for the traditional DBMS connection

As EA is so fundamentally a 32bit architecture, is EA Cloud Service tested on 64bit machines?


http://www.sparxsystems.com/enterprise_architect_user_guide/8.0/projects_and_teams/connect_to_oracle_via_odbc.html

[Eve]

Yes, it runs on 64bit machines.

Check that the drivers you are using are 32 bit drivers, if you're using ODBC make sure that you have set up a system connection (not a user one) using the 32bit odbc administrator. (C:\Windows\SysWOW64\odbcad32.exe)