I've exact same symptoms as described in
http://forums.mysql.com/read.php?65,646707,646707#msg-646707.
OS: Win 10 64 bit Professional
MySQL:
MySQL Workben: 6.3.7 build 1199 CE (64 bit) Community Edition
Access Product: Not Installed
Access ODBC Driver: 14.00.7010.1000 64 bit
As mentioned in above post: Documentation shows Access as an option in Database System combobox but I've not Access option so chose Generic RDBMS.
Database System: Generic RDBMS
Connection Method: ODBC Data Source
DSN: Valid DSN
Below is log from Fetch Schema List screen:
Starting...
Connect to source DBMS...
- Connecting to source...
Connecting to ...
Opening ODBC connection to DSN=BTLicUpd...
Connected
Connect to source DBMS done
Check target DBMS connection...
- Connecting to target...
Check target DBMS connection done
Retrieve schema list from source....
- Checking connection...
- Fetching catalog names...
- Fetching schema names...
- Fetching schema names from D:\Dev\BTechSoft\Received Files\BTLicense - Upd.accdb...
- Finished
Retrieve schema list from source finished
Finished performing tasks.
Now, clicking Next takes me to Schema Selection screen but there is no schema listed and the Next button is disabled.
I wrote a little PowerShell script and connecting to same DSN and it successfully lists all the tables. So, obviously the Access file itself is good; the DSN is good too. Something is amiss in MySQL Migration Utility.
PowerShell Script:
$conn = new-object System.Data.odbc.odbcconnection
$conn.ConnectionString = "DSN=<ValidDSN>;Uid=Admin;Pwd=<validPwd>;"
$conn.Open()
$schema = $conn.GetSchema("Tables")
echo $schema
Please help. Our ability to use MySQL in place Access hinges on successful migration of current Access db. Thanks.