Book a Demo

Author Topic: problem while importing db schema  (Read 2773 times)

bacique

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
problem while importing db schema
« on: February 11, 2009, 02:22:42 am »
Hi!
I'm trying to get DB model from Oracle 10i imported via ODBC. I managed to connect to database successfully and can see all the objects (functions, procedures, sequences) except tables.

Has anyone had similar problem?

I'm using EA 7.0.818 and Oracle 10i DBMS.
I'm sure about DB login and password - all seems fine connected to the database via Oracle Developer.

Thx!
Bacique

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: problem while importing db schema
« Reply #1 on: February 11, 2009, 08:02:05 am »
Are you using Oracle's ODBC Driver? The "Microsoft ODBC For Oracle" driver doesn't work.

bacique

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: problem while importing db schema
« Reply #2 on: February 11, 2009, 08:23:41 pm »
I tried only Oracle ODBC/JDBC client downloaded from OTN with edited tnsnames.ora file, however EA required also windows odbc for oracle DSN configured...