I can't connect to oracle from Enterprise Architec

[AlcoaACESEA]

Always have ora-00942 : Table or view does not exist
But I'm able to connect to this database using sql.
Can someone provide some guidelines to fix this ?

Thanks

[Geert Bellekens]

Probably a user rights issue.
Contact Sparx Support if you need more help.

Geert

[AlcoaACESEA]

Yes but I can connect to oracle with the user using sql.
Do I need to define oracle user in EA ?

[kepNCI]

Had the same issue. Was fixed when I updated Oracle ODBC driver to the latest r10 version. Was using the Oracle 8 ODBC driver, which as you stated, worked fine with SQL as well as with ODBC using MS Access and MS Visio. Even Vision was able to re-engineer the database.

Had to install Oracle 10 client in order to get the latest Oracle driver. In addition to creating new ODBC data sources with the new driver, One needs to make sure ORACLE_HOME parameter is set to the location of the new ODBC driver.  

Note: I do not recommend the following, but for non-EA related reasons, I was not able to reset my ORACLE_HOME and/or PATH. Insetad I took a risk and copied the v10 ODBC DDLs into the existing ORACLE_HOME file (as seen in my PATH), thus overwriting the v8 DDL files. I looked at the documentation on Oracle for Instant Client to identify the ODBC DDLs. This worked and I did not have to create new ODBC data sources.)