Migration Toolkit

[JackD4ME]

I am just getting started trying to convert an access db to mysql and decided to use the migration toolkit. I get through the source and target ok (although I am not sure what port to use so I put in port 25) but once it trys to connect I get this error listed below. Any ideas as to what is causing it not to connect?
-------------------------------------------------------------------------------
Driver class com.mysql.jdbc.Driver
Opening connection ...
Connection jdbc:mysql://keith:25/?user=keith&password=
Create a dummy schema list because Access only has one schema for each file.
Return schemata list.
Schemata names retrieved successfully.
The connection to the target database could not be established (error: 0).
Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused: connect

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection refused: connect
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1699)
at com.mysql.jdbc.Connection.<init>(Connection.java:405)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.mysql.grt.modules.ReverseEngineeringMysqlJdbc.testConnection(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.mysql.grt.Grt.callModuleFunction(Unknown Source)


** END NESTED EXCEPTION **


Details:
com.mysql.jdbc.Connection.createNewIO(Connection.java:1764)
com.mysql.jdbc.Connection.<init>(Connection.java:405)
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringMysqlJdbc.testConnection(Unknown Source)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)

 

[TonyGroves]

The default port for MySQL is 3306. Leaving the port field empty will probably work.

 

[JackD4ME]

Thanks, I put the port in and got to the next step. When I left it blank it generated a different error. Now it bombs at the reverse engineering step (step 1). Again, here is the error (any ideas?):

Initializing JDBC driver ...
Driver class sun.jdbc.odbc.JdbcOdbcDriver
Opening connection ...
Connection jdbcdbcriver={Microsoft Access Driver (*.mdb)};DBQ=L:\cidweb\OilGas\Family\Campaign\Pics\db2.mdb;DriverID=22;READONLY=true;UID=keith;PWD=}
The schema could not be reverse engineered (error: 0).
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Details:
sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringAccess.reverseEngineer(Unknown Source)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)