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

Go_interactive · « **on:** October 04, 2007, 06:45:12 am »

I want to import tables from my mysql databas with a ODBC connector. The connector is ok, have tested it but when I try to import it I get the error message:
"Unable to obtain table information".

I Use the Project-Database engineering- import databs schema from odbc. And it is when I add the odbc the popup Unable to obtain table information hits me.

Martin Terreni · « **Reply #1 on:** October 04, 2007, 09:13:12 am »

Try leaving the "schema" field empty.

Go_interactive · « **Reply #2 on:** October 04, 2007, 10:52:35 pm »

I don´t wirte in any schema.
The wierd thing is that if I connect the a mysql database on a linux server with vpn it works, but if i try to connect to my localhost mysql or a mysql on another computer on our intern network it fails.
I got the 6.5 version if it helps and 5.0.45 on my mysql

Martin Terreni · « **Reply #3 on:** October 04, 2007, 11:18:15 pm »

1) Is EA installed on Linux or Windows?
2) How did you configure ODBC (which checkboxes have you checked)? do you have a DSN for each DB all configure the same?
3) Are the privileges the same for all of them?

Try to connect with a MySQL client (there are free ones) and see if it a problem only with EA.

Go_interactive · « **Reply #4 on:** October 05, 2007, 12:25:03 am »

1) EA is installed on Windows?
2) On the linux mysql version I have checked the
"Don´t optimize column width", "Return Matching Rows".
On the windows XP database I dont have any box checked.
I have tested to check the same boxes as in linux but no result.

3) If you mean the user privileges so, yes.

Go_interactive · « **Reply #5 on:** October 05, 2007, 12:30:43 am »

I have of course tested the odbc connection when I create it. push the "Test" button. I use the odbc 3.51.15 connector.

Martin Terreni · « **Reply #6 on:** October 05, 2007, 12:41:30 am »

There is already 3.51.20.

try this client:
http://www.askfiles.com/Business/Database-Management/DreamCoder-for-MySQL-Free-Edition.html

Go_interactive · « **Reply #7 on:** October 05, 2007, 02:53:46 am »

It works perfekt with the "your" client and I have also tested with navicat 8.0 .
So it looks like the problem is in EA.

Martin Terreni · « **Reply #8 on:** October 05, 2007, 03:04:31 am »

Interesting. I think you should indeed open a bug with link to this thread. and I would appreciate it if you kept this thread updated with the results.
thanks.

JShukert · « **Reply #9 on:** January 04, 2008, 09:14:28 am »

I received the "Unable To Obtain Table Information" error when trying to reverse engineer an Oracle database from Windows XP 64 bit. It worked from Windows XP 32 bit.

«Midnight» · « **Reply #10 on:** January 04, 2008, 09:30:10 am »

First, check that you are using build 818, which was released after this bug was reported.

If the problem persists in build 818, please open a bug report. Since this flaw has not (apparently) been resolved, this may give Sparx more information.

You can get to the correct page by clicking the Report a Bug link below the Support link at the bottom of any forum page.

Please include the URL of this thread when you make your bug report, so Sparx can tie the two reports together.

Sparx Systems Forum

News: