Book a Demo

Author Topic: Unable To Obtain Table Information  (Read 3811 times)

jmelgare

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Unable To Obtain Table Information
« on: January 19, 2011, 09:15:08 am »
Hi, all

I'm trying to use the option "Import DB schema from ODBC source" with oracle 11g and Windows 7, but when I try to select the ODBC data source a popup appears saying "Unable To Obtain Table Information" and so, I can't use this option to make a reverse engineering from my database.

Somebody has any idea?, It's possible to import a db schema in windows 7?

NOTE: I have EA8.

Best regards.
Thanks in advance.
Back to top        

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Unable To Obtain Table Information
« Reply #1 on: January 19, 2011, 05:40:46 pm »
Hi,

Those type of errors are usually due to
- The type of odbc driver (EA is really picky about that)
- Not having enough rights on the database (always seems to be an issue with Oracle)

I would also suggest to search the forums for keywords "oracle" and "odbc". That should result in quite a lot of posts.

Geert

PS. use the top left search button, and pay attention to the search options.

jmelgare

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: Unable To Obtain Table Information
« Reply #2 on: January 22, 2011, 01:28:41 pm »
Thanks, Geert.

I'm still having same problem.
I think it's something with windows 7 permissions.

Any other idea?

Juan Manuel

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Unable To Obtain Table Information
« Reply #3 on: January 22, 2011, 01:40:51 pm »
Quote
Any other idea?

Nope, all out of ideas. You better ask Sparx support for help.

Geert

jmelgare

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: Unable To Obtain Table Information
« Reply #4 on: January 27, 2011, 03:35:38 am »
Hi, maybe this helps somebody out there.

I solved this issued by uninstalling Oracle Client 11G (no certified version for windows 7) and get a new installation of Oracle Client 10g for windows vista/7.

See you
J.M.