Cannot import Tables from Oracle ODBC Datasource

[ashaikh]

I created an Oracle ODBC Datasource. From EA when I try to reverse engineer and select the ODBC DS - I get the error Unable to Obtain Table information. The ODBC DS has been tested for connectivity . I would have expected EA to prompt for password since the ODBC DS doesn't store the password.

[stan2011]

Why there is no answer from EA support???

I have the same problem.

[KP]

Why there is no answer from EA support???

Because this is a user forum. Please send in a support request using the "Report a Bug" link at the bottom of this page.

[stan2011]

I paid for this software. I expect it to behave as advertised. I don't understand why it does not work.

[stan2011]

I did. This is issue causes me a lot of pain. I am  sitting in my vacation house  on the shore of the beautiful lake and instead of swimming  in it I   need to exchange e-mails with you. I preached your software at any place I could but now I have second thoughts about it.

[stan2011]

And moreover it happens on the 4th of July. What is the strange coinsendence?

[stan2011]

I need my answers now!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!1
Can EA really import schema from ORACLE or it is only marketing ballony??? Please let me know and I will let all my friends know.

[Geert Bellekens]

Stan,

Have you tried searching the forum for things like "ODBC" and "Oracle"?
(use the top left search button, not the top right search box)
IIRC EA is pretty picky on what database driver you are using.

Geert

PS. I don't think the 4th of July makes any difference at all since Sparx is located in Australia

[Hardy]

I am having same problem here now.

According to EA's document I isnatlled Oracle ODBC driver instead of Microsoft Oracle ODBC. I have tested the connection and my ODBC setup should work.

Inside EA 8.0.858 I got exactly same message "Unable to Obtain Table information".

Any progress of this issue?

[Ulises Fasoli]

Same problem here with an Oracle Database 10g. Hope someone finds a way to get it working

[Hardy]

I sent an email to Sparx technical support, they replied that they could not reproduce the problem.

[Ulises Fasoli]

I'm not sure it's going to help anyone, but I got it working.

I had to reinstall my oracle client and ODBC drivers, then define the environnement variables :

* ORACLE_HOME : C:\app\ufasoli\product\11.2.0\client_1
* PATH : Add the client's BIN folder to the PATH (C:\app\ufasoli\product\11.2.0\client_1\bin)

Finally restart the computer



Note : the values here correspond to my environnement


Long time ago I had a problem with another software that couldn't find ORACLE_HOME even though it was defined in a variable. As it turns out the installer (under Windows 7 64bits) was not able to write it down on the windows registry and I had to do it manually under  :

/HKEY_LOCAL_MACHINE/SOFTWARE/Wow6432Node/ORACLE/ORACLE_HOME

[lubomir]

I have the same problem (Unable To Obtain Table Information). Doesnot matter if I use Microsoft ODBC driver or from Oracle. My environmet:
Server: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
Client: Oracle Developer Suite 10.1.2.0.2
ODBC: 10.1.0.5.0
OS: Windows 7
Connection test with Oracle driver is succesful. I add enviroment variable ORACLE_HOME, but it doesnot work anyway.

[Ulises Fasoli]

Quick question, your client is it 64bit or 32bit (I think Enterprise Architect works only with 32 bit)

[lubomir]

It is old one (2006), so I suppouse, that 32 bit version. There is only one posibility (http://www.oracle.com/technetwork/database/windows/downloads/utilsoft-098155.html)