Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: rs-apa on February 18, 2010, 12:00:55 am

Title: Import of DB Schema from ODBC/Oracle: no tables
Post by: rs-apa on February 18, 2010, 12:00:55 am

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.

Title: Re: Import of DB Schema from ODBC/Oracle: no table
Post by: e.martin on February 23, 2010, 02:07:40 am

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

Title: Re: Import of DB Schema from ODBC/Oracle: no table
Post by: macgoofy on February 26, 2010, 01:20:58 am

I've the same problem.

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

Greetings
Macgoofy

Title: Re: Import of DB Schema from ODBC/Oracle: no table
Post by: André Figueiredo on March 24, 2010, 11:53:28 pm

Yes.
I have also the same problem.

You already have an answer for this issue?

Thanks.
André Figueiredo

Title: Re: Import of DB Schema from ODBC/Oracle: no table
Post by: hd on March 25, 2010, 07:51:59 am

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

Title: Re: Import of DB Schema from ODBC/Oracle: no table
Post by: André Figueiredo on March 25, 2010, 08:54:10 am

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

Title: Re: Import of DB Schema from ODBC/Oracle: no table
Post by: Eve on March 25, 2010, 10:52:12 am

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

Quote

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.

Title: Re: Import of DB Schema from ODBC/Oracle: no table
Post by: André Figueiredo on March 25, 2010, 10:02:20 pm

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

Quote

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

Title: Re: Import of DB Schema from ODBC/Oracle: no table
Post by: Eve on March 26, 2010, 08:49:25 am

I know nothing about that error myself.  If you haven't done so already, please submit a support request using this form (http://www.sparxsystems.com/support/bug_report.html).

Title: Re: Import of DB Schema from ODBC/Oracle: no table
Post by: André Figueiredo on March 26, 2010, 09:13:59 am

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.