I am testing Enterprise Architect (Corporate edition). Probably we want to buy it for development in the company I work for (if we can get the DB connection work
.
Unfortunately, after installing the official ORACLE ODBC driver (on a Windows XP machine) following happens:
1. After clicking "Connect to Server Repository..." I get the Data Link Properties window where I select "ORACLE Provider for OLE DB".
2. Then in the Connection Tab I entered in Data Source a valid name (a name found in the tnsnames.ora file). After providing my user name and password I clicked "Test Connection" here I get: "Test connection succeded".
3. I click on OK in the Data Link Properties window.
4. I get a new Window Connection Name & Type. I entered a name and click then OK.
5. An Enter Password window appears, I write there the password to access the database again (already given in step 2.) and then click OK.
6. A window with title "EA" appears with the following message: "OraOLEDB [-2147217865] ORA-00942: table or view does not exist" and an OK button.
7. After clicking OK I get a new window with title "EA" and the following message "Enterprise Architect has experienced a network error and will close down"
8. I can only click on OK, EA is closed automatically.
I repeated the procedure with two different ORACLE instances with the same results.
Does anybody have a clue why the connection isn't performed? EA wants to access a table which he doesn't finds, which table is that?
Thanks in advance for your help.
