There could be several possible reasons that prevent you from successful connection to remote database. If the error message says "Can't connect to MySQL server on ?some host' (10061)" then probably you should check the correctness of port and host name you've entered and also if the remote server is run. It often happens that the port through which the connection is set with MySQL server (normally, it's 3306) is closed for the security reasons by local firewall, corporate firewall or remote server firewall. The remote server port can also be closed by ISP, or TCP/IP protocol support is disabled on MySQL server. Please check this with your system administrator or ISP. If the error message says "Access denied for user: root@somehost.somedomain" or "Host not allowed to connect to server", then the reason is that the user doesn't have permission to access the database.

There are several reasons why you cannot connect to the local database. If during the connection you get the error "Can't connect to MySQL server on 'localhost' (10061)", then probably MySQL server is installed incorrectly or the service (usually with the name "mysql") is not running. To check if the service is launched, open "Control Panel" -> "Administrative Tools" -> "Services" and find the MySQL service. If you cannot find this service, you should try to reinstall MySQL. In case you find it, run it with the Start button or use Start item in the context menu. If you get the error "Access denied for user 'root'@'localhost' (using password: YES)", then check if you enter the password for the root user correctly in case you change it during installation. If you installed MySQL with default values, you should use the user name root with the blank password and port 3306 to connect to the server.

Make sure that "\bin" folder is in PATH, and that some version of oraxy.dll, e.g., oci.dll, ora71.dll, ora72.dll, etc. exists in that folder or elsewhere in the PATH. For Oracle8, the OCI dll is named OraClient8.dll. For Oracle9, the OCI dll is named OraClient9.dll.

First, I recommend you to choose ODBC connection type on the second step of the Wizard to achieve maximum transfer speed, to extract full information about your database structure and to avoid various problems you may have while working through the OLE DB Provider for ODBC. To get connected to your source database through ODBC, you should install an appropriate ODBC driver for your database. Below are the links where you can download latest versions of ODBC drivers for your database: MySQL: http://dev.mysql.com/downloads/connector/odbc/ PostgreSQL: http://pgfoundry.org/projects/psqlodbc/ Firebird: http://www.firebirdsql.org/ or http://www.ibphoenix.com/

This error occurs because you don't have a permission to connect to remote MySQL server from your host. Please contact your database administrator or, if you have access to MySQL server with grant privilege, you can use the GRANT statement to add a new user. For example, the following command will give full access from your host to the user: /*!50003 CREATE USER 'user'@'user_host'*/; GRANT ALL PRIVILEGES ON *.* TO 'user'@'user_host' IDENTIFIED BY ' user_password ';