Oracle reverse engineer sees no tables?

[lauriechan]

hi,
I'm trying to reverse engineer a data model from Oracle 10g and the list of available objects is showing sequences *only*; ie not tables, views, triggers or anything else.

Can anyone provide clues as to what I might be doing wrong or how to get this to work?


Some addititional info:

The sequences are in the same schema as the tables so I'm assuming that's evidence that it successfully connected to the database and it is the correct schema.

I only have the one database to try this with but get the same behaviour with any schema within that database.

I can reverse engineer the tables etc happily with trial versions of ER/Studio and TOAD Modeller although they both use direct Oracle drivers rather than ODBC.

I can open the odbc datasource with MS Excel and it sees all the tables and views that EA can't seem to find using the same odbc datasource.

I am using the Microsoft ODBC driver for Oracle as I need to patch my Oracle client up to 10.1.5.0 to install the odbc drivers from the oracle site and getting the patch/upgrade is taking quite a bit of time. Could this be the problem? ie do I need to use Oracle's odbc drivers rather than Microsofts?

[«Midnight»]

Here's a long shot.

Check the dialogs for forward (just in case) and reverse engineering databases. In at least the forward engineering case you are allowed to specify what will be included in the operation. Each of the components you mention can be selected via a check box. [Note that the default selection has tables and selected but triggers and sequences not selected, thus the long shot.] See if you somehow have only got sequences selected in either direction (again, just in case the settings have broad effect).

David

[lauriechan]

hi,
thanks for trying David :-)
I have tried all sorts of variations on ticking and unticking the checkboxes to no avail other than workign out that it caI worked out that it can at least see the sequences.

Laurie

[«Midnight»]

Things to try:

Make sure you are using a system DSN, not a user DSN.

Check out a patch for Oracle ODBC drivers that allows you to choose whether to specify hints when connecting. Apparently unchecking this option helps in some circumstances. The patch was originally released sometime around late 2005, but I don't have details. There is supposed to be a server-side patch as well.

David

[lauriechan]

yay...
I finally managed to upgrade my oracle client to 10.1.5.0 and was then able to install the the matching oracle ODBC drivers (the Oracle site has no odbc drivers for 10.1.2.0)and it has solved the problem.
Evidently the "Microsoft ODBC for Oracle" drivers aren't good enough for EA to work with.

Thank you to everyone for your suggestions.

[«Midnight»]

Thanks Laurie,

I'll update my drivers.

David