Book a Demo

Author Topic: Unable to load Database Schema using Oracle ODBC  (Read 3125 times)

hiub

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Unable to load Database Schema using Oracle ODBC
« on: February 27, 2009, 11:22:26 pm »
I'am trying to set up a connection with my EA 7.1.832 (Build 832) via ODBC driver Oracle in XE Client 10.02.00.01.

Testing defined connection in Microsoft ODBC administrator is succesfull. But when i try connect to it in EA I'have strange situation:
- when i try to make it first time, I can see list of tables, but message "Unable to obtain table information" is shown after selection
- nex time list of tables does not prelude message "Unable to obtain table information" ("Error retrieving table list" is shown).

How can I solve it? Anybody had similar problem and solved It?

juhi

  • EA Novice
  • *
  • Posts: 15
  • Karma: +0/-0
    • View Profile
Re: Unable to load Database Schema using Oracle OD
« Reply #1 on: March 02, 2009, 09:04:29 am »
Please use Oracle ODBC Driver.

Juhi
Sparx Systems Pvt Ltd
[email protected]

hiub

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: Unable to load Database Schema using Oracle OD
« Reply #2 on: March 02, 2009, 07:31:54 pm »
Juhi, I think i use it.
My driver is:
ODBC driver Oracle in XE Client 10.02.00.01.

Antares

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Re: Unable to load Database Schema using Oracle OD
« Reply #3 on: March 03, 2009, 03:59:25 am »
Hi,
I had the same issue with the standard ODBC driver. I then used the Oracle home client on my machine, which was listed at the bottom of the connections dialogue. This worked fine.