Table of contents
- What is EMS Data Pump for MySQL utility?
- What do I need to start working with EMS Data Pump for MySQL?
- I‘ve downloaded a trial version of EMS Data Pump for MySQL, but not all records of the tables are converted. What’s the reason for this?
- I’m trying to import data from MS Access. When I open up a table it shows indices(0), constraints(0) and I cannot select them. How can I fix this?
- When I try to connect to a database, I get the following message: Access denied for user: user@host.domain Why does it happen?
- I'm testing Data Pump utility to convert a MS Access 2000 database to MySQL but it raises an error of access violation in module msjet40.dll.
Q:
What is EMS Data Pump for MySQL utility?
A:
EMS Data Pump for MySQL is a powerful utility for converting databases and importing table data from an ADO-compatible source (e.g. MS Access or any other database with ADO support) to MySQL databases. Easy-to-use wizard application allows you to build the ADO connection string, select tables, fields and indices for converting, view and edit SQL script for generating target MySQL database and select tables for import. Data conversion becomes as easy as possible with EMS Data Pump for MySQL!
Q:
What do I need to start working with EMS Data Pump for MySQL?
A:
First of all you must have an opportunity to connect to some local or remote MySQL server. Besides you need your computer to satisfy the system requirements of EMS Data Pump for MySQL.
Q:
I‘ve downloaded a trial version of EMS Data Pump for MySQL, but not all records of the tables are converted. What’s the reason for this?
A:
This is a limitation of the trial version which converts only 10% of all records. With a registered version all the records are processed.
Q:
I’m trying to import data from MS Access. When I open up a table it shows indices(0), constraints(0) and I cannot select them. How can I fix this?
A:
The solution to this problem is to use the Microsoft Jet OLE DB Provider in order to establish connection to your Access database.
Q:
When I try to connect to a database, I get the following message: Access denied for user: user@host.domain Why does it happen?
A:
This error is generated by MySQL server because you don't have privileges to connect to the server from your host. Please contact your database administrator to resolve this problem.
Q:
I'm testing Data Pump utility to convert a MS Access 2000 database to MySQL but it raises an error of access violation in module msjet40.dll.
A:
Try to reinstall the Microsoft Data Access Components (MDAC) 2.8. You can download it from the page http://www.microsoft.com/downloads/search.aspx?displaylang=en