Import of DB Schema from ODBC/Oracle: no tables

[rs-apa]

we are using ea 7.5.849
with one of our oracle-database (10g) we have got the problem that no tables are listed after starting the import. the odbc-connection is working (tried with other tools, listing all tables - e.g. excel)!
when trying to retrieve the objects just
 - sequences and
 - procedures
are listed.
no tables at all.
have you got any hint?! which views are used for this? the user_tables is accessible for the user we start the reverse engineering task.

[e.martin]

Hello,

I had the same problem with a SQL Server database. I solved it indicating the schema in the declaration of the ODBC datasource (you can specify the schema you want in replacement of the default one). It is maybe the same for Oracle...

Emmanuel

[macgoofy]

I've the same problem.

But the solution above didn't solve it. Any other suggestions?

Greetings
Macgoofy

[André Figueiredo]

Yes.
I have also the same problem.

You already have an answer for this issue?

Thanks.
André Figueiredo

[hd]

Are you using Oracle's ODBC driver? The Microsoft ODBC for Oracle driver won't work.

[André Figueiredo]

Yes, i'm working with Microsoft ODBC Driver.
And i realise that it could not be the best driver.

I've tried the Oracle ODBC Driver, but i got the following error:
"Unable to Connect. Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"

I reinstall the driver in other machine, but it is always the same.
But i have a colleague where it works fine for him (but is Oracle11g and i'm using Oracle 10g).

Well, but it is official that with Microsoft ODBC doesn't work?
Thanks

[Eve]

From http://www.sparxsystems.com/uml_tool_guide/data_modeling/importdatabaseschemafromod.html

The ODBC connection should use the ODBC driver available from the DBMS vendor. For example, MySQL's ODBC driver for MySQL, and Oracle's ODBC driver for Oracle. Drivers provided by third-party vendors are not supported - this includes the Microsoft ODBC driver for Oracle.

[André Figueiredo]

And what about this error?? Any help? Yes, i'm sure about the connection data, user, pass and everything.

I've tried the Oracle ODBC Driver, but i got the following error:
"Unable to Connect. Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"

[Eve]

I know nothing about that error myself.  If you haven't done so already, please submit a support request using this form.

[André Figueiredo]

I don't know how and why, but i think that was after the DB server restart that the connection begun to work, and reverse worked fine.

But, after some time, in one of developers machine it doesn't work again, with the same error.

I don't understand the reproducity steps.
Thanks anyway.