Book a Demo

Author Topic: Unable to obtain table information  (Read 6191 times)

wallytalen

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Unable to obtain table information
« on: July 11, 2012, 08:11:51 am »
I run Oracle 11.2.0.3 64 bit RDBMS on a Windows Ultimate 7-64 bit notebook. I've Oracle 11.2.0.3 64 bit client installed in a separate Oracle home as well. I can do SQL*Plus and JDBC connections to the database.

I can also connect to the database using both the 32 bit and 64 bit ODBC administrator consoles. I've defined both 32 bit and 64 bit ODBC data sources for which the 'Test Connection' button works successfully.

When I select the 32 bit ODBC data source (64 bit not used by EA) I immediately get a dialog 'Unable to obtain table information'. I can't reverse-engineer Oracle databases?

I've run the $ORACLE_HOME\ASP.NET\SQL\InstallAllASPNETProviders.sql. Still "no soap"  :(

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: Unable to obtain table information
« Reply #1 on: July 11, 2012, 11:56:41 am »
You need to install the 32-bit Oracle client.