Author Topic: Import of DB Schema from ODBC/Oracle: no tables  (Read 3254 times)

rs-apa

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Import of DB Schema from ODBC/Oracle: no tables
« 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.

e.martin

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: Import of DB Schema from ODBC/Oracle: no table
« Reply #1 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

macgoofy

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: Import of DB Schema from ODBC/Oracle: no table
« Reply #2 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

André Figueiredo

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: Import of DB Schema from ODBC/Oracle: no table
« Reply #3 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

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: Import of DB Schema from ODBC/Oracle: no table
« Reply #4 on: March 25, 2010, 07:51:59 am »
Are you using Oracle's ODBC driver? The Microsoft ODBC for Oracle driver won't work.

André Figueiredo

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: Import of DB Schema from ODBC/Oracle: no table
« Reply #5 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
« Last Edit: March 25, 2010, 10:00:06 pm by pandresfigueiredo »

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 7615
  • Karma: +96/-18
    • View Profile
Re: Import of DB Schema from ODBC/Oracle: no table
« Reply #6 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.
Eve

support@sparxsystems.com

André Figueiredo

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: Import of DB Schema from ODBC/Oracle: no table
« Reply #7 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"
« Last Edit: March 25, 2010, 10:05:33 pm by pandresfigueiredo »

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 7615
  • Karma: +96/-18
    • View Profile
Re: Import of DB Schema from ODBC/Oracle: no table
« Reply #8 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.
« Last Edit: March 26, 2010, 08:49:44 am by simonm »
Eve

support@sparxsystems.com

André Figueiredo

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: Import of DB Schema from ODBC/Oracle: no table
« Reply #9 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.