Unable to Obtain Table Information

[Geoff Cartwright]

Hi,

I am using EA V6.5 under Windows XP.

I am trying to read the tables definitions etc of an ORACLE database using the "Import DB schema from ODBC source" option. I already have some .DSN files which work fine with MS-Office 2007 products accessing the Dbs.  

When I try to "Import" the schema I get "Unable to Obtain Table Information" error message from EA.  Any ideas?

Cheers,
Geoff

[ning]

First, Which version of Oracle are you using? On current release EA version 7.1 build 829 support Oracle 9i, Oracle 10g, Oracle 11g.

Following using Oracle 10 for example.

Second, make sure your Setup the Net Configuration Assistant. Please goto All Programs | Oracle -Ora Client10g-home1 | Configuration and Migration Tools | Net Configuration Assistant.
 
-> Select Local Net Service Name Configuration - Next Add - Next Enter
-> Service Name which is Oracle Database Name -> Next Accept TCP - Next
-> Enter HostName - Next (Use the standard port number of 1521) Yes,
-> perform a test - Next Change Login(User name and password) The screen
-> should show "Connecting ...Test successful".
-> Next - Next - Finish

Third, make sure your ODBC driver setup successful, using Oracle 10g for example

-> Define Data Source Name
-> TNS Service Name which is Oracle Database Name
-> User ID which is user name
-> Click on Test Connection button Enter Password The screen should
-> Does Show "Connection Successful" ?

Fourth, when you do Import DB schema from ODBC source please type user ID in Schema/Owner at Filter.

please also check your configuration of your Oracle client. See you have permission in the database or not.

Hope can help you!

Best Regards,

ning

[Geoff Cartwright]

Hi Ning,

Thanks for your reply .

I am sorted now.  EA was being invoked by an in-house .cmd file which set up an ORACLE environment which overrode my default ORACLE environment...  

Cheers,
Geoff

[Peter A.]

Hello  I have exactly the same problem (Windows XP/SP2, EA 7.1, Oracle 10g) I Followed all the configuration steps on this forum thread.   I have recreated the DSN, and re-entered EA.  No luck.  

The same DSN works in Access and all table info can be retrieved.


I use TcpViewer and see that EA constructs a TCP connection to the database, but never uses it to transfer data.  There are no error messages of any kind.  


Are there any other ideas out there?