Problem in connectiong to SQL Server from EA

[ott_rs]

I followed the steps given in the help of EA to connect to SQLSEVER. The connection is successfull but when I open the project it gives several error like 'Invalid object name 't_stereotype'  and does not open the project.
Any help is appreciated.
Thanks

[Bruno.Cossi]

Have you run the SQL script in order to create the tables? And if so, does the user you are connecting to SQL server as have access to those tables?

Bruno

[ott_rs]

Bruno ,
No I am not runing any script .I am connecting to sql server using the user id which has all the previledges. Once the connection is successfull it should bring the database objects to EA , but  despite teh test connection being successfull , it doesn't  bring the database object into EA ie it doesn't open teh project at all and gives teh error.

[Bruno.Cossi]

If I understand it correctly, you are trying to reverse engineer database objects into EA, correct?
There is a difference between that and between opening an EA project from the database. The EA project may be stored in a file (the .EAP file you have certainly noticed) or it may be stored in a relational database (MS SQL Server, Oracle, MySql). In order to be able to opena  project from a database, you must first create set of database tables that the project will be saved to.
As you are connecting to a database, I assume you have a Corporate version of the EA. You can find more details about creating the EA structure in the database here: http://www.sparxsystems.com.au/registered/reg_ea_corp_ed.htm
Now, reverse engineering tables from a database (which, I am guessing, is what you want to do), is done diffeently. Access menu Project > Database engineering to do that.

Let me know if you need more help!

Bruno

[ott_rs]

Thanks for the detailed reply,Bruno. Problem still remains.

Yes, I want to do reverse engineering and I tried doing that from the menu Project/Database Engineering. Here we have two submenu.When I click on 'Import DBSchema fromODBC' I get the message that 'Please select a diagram to import the DDL information into.' I expected the facility of getting the odbc connection here.

And the other option is Generate Package DDL.Clicking on this I get a screen where I should be able to select the table but don't get the list of table so can't proceed ahead there too.

I am using Corporate Version of EA. t seem to be straight forward if I get the option of choosing the DSN(ODBC) for getting data.

Please let me know what I am missing here .

Thank you ,
Rekha

[Bruno.Cossi]

Hi,

the database tables will be reverse engineered into classes. Start wit creating new empty class diagram. Once you do that, go to Project > Database Engineering > Import DB Schema from ODBC.
In the window that opens next, click on the button next to the field "Database Name" and select the ODBC connection to the database that you want to reverse engineer. Make sure that you have setup the ODBC connection first!
If you want to reverse engineer a particular schema, enter it in this window, too. Click on "Import" and you should be in business!

Bruno

[ott_rs]

Hi ,
I don't get the window to select the ODBC connection. As sson as I click on the 'Import DBSchema from ODBC ' I get error message saying that 'Please select a diagram to import the DDL information  into.' I do have the ODBC connection set up for the database but do not get the window to select any.

Is something missing in the software version I have ?

Thanks,
REkha

[Bruno.Cossi]

No, as I have said, youf rist have to create new Class diagram into which the database tables will be reverse engineered. Create the class diagram, select it in the Project Browser and only then go to "Import DB Schema...."

Bruno

[ott_rs]

I got it. The mistake I was doing was ,I didn't insert the diagram. Once I insert the digram for classes,I get the window to select the ODBC.


Thanks a lot.
Rekha

[Bruno.Cossi]

You're welcome!