ODBC connection fails with message ...

[Tom Spitzer]

Trying to import DB schema from ODBC, under Tools -> Database engineering -> Import DB Schema from ODBC

If I choose my SQL Server data source it works.

If I choose myMySQL data source, after selecting the data source, EA displays a dialogue that says

"Unable to obtain table information".

I am able to import data from the MySQL DB into another application on my PC, so I'm sure the ODBC connection is set up correctly.

Has anybody seen/resolved this?

[nick c]

I'm having similar troubles connecting to a MySQL database via the ODBC drivers.

It's not the same issue as you, but still getting errors when trying to connect.
I've used other programs on the same computer and using the same ODBC driver and have connected successfully, so it appears to be an issue with EA.

[qwerty]

I have no idea, but it looks like an authorization problem. The table information is usually stored in some system tables with different grant privileges. Probably these are not set the right way. You should try to do that as database admin.

q.

[Tom Spitzer]

since its a development server, and theres only one user account with access to everything, I don't think its an account problem. Microsoft apps happily list the tables and run imports from them. EA does not. In fact, when you log ODBC calls you find there aren't any.

I'm wondering if EA is even detecting the MySQL driver. when I click the button in the dialogue that leads to creating a new connection, it presents a different list of ODBC drivers that the ODBC admin utility shows. This list does not include MySQL.

I'm pretty sure this is a 32 bit vs. 64 bit Windows problem. It all works as one would expect under Win 7 32 bit.

[KP]

I'm pretty sure this is a 32 bit vs. 64 bit Windows problem. It all works as one would expect under Win 7 32 bit.

Not really my area, but I know you need to run this ODBC Data Source Administrator:  C:\Windows\SysWOW64\odbcad32.exe

[Tom Spitzer]

Ah. I had not found the standalone 32 bit ODBC admin utility, but it makes sense that it would be there. In addition to that, you need to install the 32 bit MySQL ODBC driver.

You might want to publish that information - ODBC connections on 64 bit Windows use the 32 bit ODBC engine and require installing the 32 bit versions of vendors ODBC drivers.

thanks.

[RoyC]

Actually, it is in the Help. On the web site:

http://www.sparxsystems.com/enterprise_architect_user_guide/9.3/database_engineering/importdatabaseschemafromod.html

And in the installer Help, in Database Engineering > Import Database Schema.

You could also look at Projects and Teams > Server Based Repositories > Create a Project in a MySQL Database > Set up a MySQL ODBC Driver

[Tom Spitzer]

guess it helps to read the fine print.