關于Unable to Obtain Table Information in Enterprise Architect - MySQL錯誤的解決

今天在使用EA逆向工程從ODBC導入資料庫的過程中發現Unable to Obtain Table Information,嘗試用ANSI/UNICODE不同的方式 建立ODBC仍然還是提示Unable to Obtain Table Information,,環境是WIN7,64位系統,ODBC驅動也是安裝的X64的,後來在stackoverflow上找到了答案:

If you are using a 64-bit operating system:

• Enterprise Architect requires 32-bit ODBC drivers to connect to a repository through ODBC; to set up the ODBC configuration on 64-bit clients, run the 32-bit ODBC Data Source Administrator from C:\Windows\SysWOW64\odbcad32.exe

• You can quickly load the correct 32-bit ODBC Data Source Administrator by selecting Tools | ODBC Data Sources in the Enterprise Architect menu bar

大概的意思就是你在使用64位系統的時候ODBC驅動仍然要安裝32位的,估計EA在10以下的版本中僅支援32的ODBC驅動,安裝32位MYSQL的ODBC驅動後解決