Author Topic: Oracle 10.2 unable to obtain table info (Read 3360 times)

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?

atallec · « **Reply #1 on:** August 07, 2009, 06:57:24 pm »

Hi Martin,

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

«Midnight» · « **Reply #2 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.

Martin Terreni · « **Reply #3 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...

«Midnight» · « **Reply #4 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.]

Sparx Systems Forum

News: