MySQL Forums
Forum List  »  Microsoft Access

No Schemata Listed for Access Migration
Posted by: G Raja
Date: December 11, 2016 12:56AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
No Schemata Listed for Access Migration
716
December 11, 2016 12:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.