Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: Martin Terreni on August 06, 2009, 10:55:19 pm

Title: Oracle 10.2 unable to obtain table info
Post by: Martin Terreni on August 06, 2009, 10:55:19 pm

EA 7.5.847
Oracle 10.2
When connactin with TOAD all work fine, but when tring though EA i get "unable to obtain table information". I created a use connection through ODBC and tested it and it connected succesfully.

BTW, I added the username to the schema but it didnt work.

ANy Ideas?

Title: Re: Oracle 10.2 unable to obtain table info
Post by: atallec on August 07, 2009, 06:57:24 pm

Hi Martin,

Did you install the oracle 10g express or standard edition ?

Title: Re: Oracle 10.2 unable to obtain table info
Post by: «Midnight» on August 08, 2009, 12:47:48 am

Did you explicitly specify the client-side ODBC driver supplied by Oracle when you connected from EA? Many users have reported problems when using the Microsoft driver. This happens even when they can connect to the Oracle database with the MS driver outside of EA.

Title: Re: Oracle 10.2 unable to obtain table info
Post by: Martin Terreni on August 09, 2009, 03:35:05 pm

I installed Oracle 10.2 driver and was using it. For Toad it works fine, for EA not :(

Thanks for the help...

Title: Re: Oracle 10.2 unable to obtain table info
Post by: «Midnight» on August 10, 2009, 08:30:51 pm

Check your Oracle privileges to the schema very carefully. Make sure you are allowed to write to the schema. [I do not think EA tries to do so, but IIRC it used to balk if it could not access the database with write privilege.]