ODBC Oracle problem

[dalibor rak]

Hi, I am trying to import database schema from Oracle 10g using ODBC. When I setup the ODBC and try to import objects from the database, I never get in the list of object the database tables and views, I can see just sequences and functions. Had anyone similar problem? THank you for help

[edes]

Hi,

I have the same problem. I can see the sequences and functions but the screen doesn't show the tables.

[John P]

Hi, I am having the same problem.

Did you ever get an answer to this?

Thanks

JP

[Luis J. Lobo]

Try removing the schema name from the ODBC connection window.

[John P]

Thanks Luis, but I've managed to solve the problem.

I was using the Microsoft ODBC driver for Oracle. I am now using the Oracle ODBC driver and all is working well - with schema as well.

Cheers,

JP

[z.kadlec]

Hi,
I have the same experience - Microsoft odbc driver for Oracle doesn't work with EA!

Zdenek

[beachdefender]

Hi,
I have just run into the same issue, but I was getting tables sometime ago.

I may have been using the Oracle drivers.

[«Midnight»]

Make absolutely sure you have all the necessary Oracle privileges to read the system (i.e. structural) tables for the target schema. That has sometimes been a factor in reverse engineering Oracle.

[beachdefender]

Hi,
It was actually the desktop environment here.  I was getting an error from the Oracle Drivers that requires a registry edit.

Working SOE world as I am, I needed to bring in my laptop.  Of course as I realised this I remembered that this is exactly what I did when I set up the model sometime ago.

Thanks,
Barry

[«Midnight»]

That sounds promising Barry,

But just to be sure... Did it work? Are your tables back (in the EA model that is)?

David

[dalibor rak]

it works