Skip navigation links

MySQL Forums :: Microsoft Access :: The connection to the target database could not be established


Advanced Search

The connection to the target database could not be established
Posted by: Michael Euler ()
Date: November 10, 2009 05:52AM

Hi,

I've tried to migrate a MS-Access-Database to MySQL. Migration-tool, MySQL and the Access-database are on the same machine, with a localhost installed using the XAMPP-Package.

All setting are according to the manual, however the connection to the target-database cannot be estabilshed. Following details are provided:
---

Connecting to source database and retrieve schemata names.
Create a dummy schema list because Access only has one schema for each file.
Return schemata list.
Schemata names retrieved successfully.
Initializing JDBC driver ...
Driver class MySQL JDBC Driver 5.0
Opening connection ...
Connection jdbc:mysql://localhost:3306/?user=root&password=xxxxxxx&useServerPrepStmts=false&characterEncoding=UTF-8
The connection to the target database could not be established (error: 0).
ReverseEngineeringMysqlJdbc.getVersion :Unknown initial character set index '48' received from server. Initial client character set can be forced via the 'characterEncoding' property.
Details:
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
com.mysql.jdbc.Connection.configureClientCharacterSet(Connection.java:2345)
com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:3913)
com.mysql.jdbc.Connection.createNewIO(Connection.java:2683)
com.mysql.jdbc.Connection.<init>(Connection.java:1531)
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(ReverseEngineeringGeneric.java:141)
com.mysql.grt.modules.ReverseEngineeringGeneric.getVersion(ReverseEngineeringGeneric.java:161)
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)

---
I'm sure it is a simple thing but due to lack of experience I'm not able to solve the problem by myself. May be somebody has an ideas.

Thanks a lot

Mike



Edited 2 time(s). Last edit at 11/10/2009 06:01AM by Michael Euler.

Options: ReplyQuote


Subject Views Written By Posted
The connection to the target database could not be established 5060 Michael Euler 11/10/2009 05:52AM
Re: The connection to the target database could not be established 1910 Michael Euler 11/10/2009 07:39AM


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.