Migration from Access: Password problem
Posted by: giorgio giorgio
Date: September 26, 2005 09:24AM

I have just installed MySQL Migration Toolkit 1.0.18rc on my windows xp system.
I tried to migrate data from an access 2000 database protected by a password (password is pippo) but I got an error message in the reverse engineering phase !

Error message is :

Initializing JDBC driver ...
Driver class MS Access
Opening connection ...
Connection jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=E:\Documents and Settings\Administrator\Desktop\db1.mdb;DriverID=22;READONLY=true;UID=%username%;PWD=pippo}
The schema could not be reverse engineered (error: 0).
[Microsoft][Driver ODBC Microsoft Access] Password non valida (Wrong password).
...


If I remove password from the access db everything works.

In the Souce Database window I tried to left the username field blank, I tried to type as username Admin, Administrator, Amministratore and root.

I also tried to specify the following JDBC connection String :

jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=E:\Documents and Settings\Administrator\Desktop\db1.mdb;PWD=pippo

I did not solve my problem!

How can I specify the access's password?

Thanks.
Giorgio

Options: ReplyQuote


Subject
Written By
Posted
Migration from Access: Password problem
September 26, 2005 09:24AM


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.