Frequently Asked Questions

FAQ
Here is the knowledgebase for the program. If you cannot find any solutions for your questions in here, please feel free to contact with us.
  1. Why get "[80040E14] [Informix][Informix ODBC Driver][Informix]A syntax error has occurred."
  2. Why get "Error: [80040154] Class not registered" when connect to MS Access/MS Excel?
  3. Why get "Error: -2146824582 Provider cannot be found. It may not be properly installed" error when connect to Foxpro?
  4. Why get "ERROR 1148: The used command is not allowed with this MySQL version" when migrating to MySQL?
  5. Why Excel truncate text data?
  6. SQL Server: "Unable to resolve column level collations system"
  7. DB2: Get 'Driver's SQLAllocHandle on SQL_HANDLE_ENV failed' error.
  8. Why get 'server closed the connection unexpectedly...' when migrate to PostgreSQL?
  9. Where is the migration log?
  10. "This application has failed to start because the application configuration is incorrect." on Windows XP.
  11. "Object or provider is not capable of performing requested operation." error when migrating Paradox/dBase.
  12. Got "[80040E30] Type name is invalid" error.
  13. Got "String or binary data would be truncated." error while migrating to SQL Server.
  14. ORA-12705 : Cannot access NLS data files or invalid environment specified.
  15. How to connect to Informix database?
  16. Why get garbled after migrated from FireBird/InterBase?
  17. "Unexpected error from external database driver (11265)" when migrating Paradox/dBase tables.
  18. How to connect to Oracle Server?
  19. [0x8004005] Invalid connection string attribute.
  20. General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x80c Thread 0xdf4 DBC 0xcca0ac Text'.
  21. Why get "ORA-12560: TNS:Protocol adapter error." when connect to oracle server?
  22. Cannot create a row of size XXXXX which is greater than the allowable maximum of 8060.
  23. Duplicate key value/entry error?
  24. How to speed up your conversion?
  25. Why data display as '?' after transfered to MySQL?
  26. Why "MySQL server has gone away"?
  27. Why appeared "Object was open" error?
  28. How to specify schema name for PostgreSQL?
  29. Connects SQL Server Express 2005 failed.
  30. Why get ORA-32101 or ORA-32104 when creating environment?
  31. How to setup FireBird/InterBase database connection?
  32. Why appears "Can't connect to host or database" message?
  33. How to running command line?
  34. How to converts
  35. Convert to mySQL 3.x error?

1) Why get "[80040E14] [Informix][Informix ODBC Driver][Informix]A syntax error has occurred."

Please run IBM Informix Setnet32 in client, and set "DELIMIDENT" to y.

2) Why get "Error: [80040154] Class not registered" when connect to MS Access/MS Excel?

Please install: Microsoft Access Database Engine 2010

3) Why get "Error: -2146824582 Provider cannot be found. It may not be properly installed" error when connect to Foxpro?

Please install: OLE DB Provider for Visual FoxPro

4) Why get "ERROR 1148: The used command is not allowed with this MySQL version" when migrating to MySQL?

You should enable LOAD DATA LOCAL commands in MySQL by adding the following to "my.cnf" and restart MySQL:
local-infile=1

5) Why Excel truncate text data?

Please change "TypeGuessRows" to 0(default is 8) in registry:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access Connectivity Engine\Engines\Excel

or

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Access Connectivity Engine\Engines\Excel

6) SQL Server: "Unable to resolve column level collations system"

Please install hotfix from Microsoft: http://support.microsoft.com/kb/954920

7) DB2: Get 'Driver's SQLAllocHandle on SQL_HANDLE_ENV failed' error.

Adding your user ID to DB2ADMNS and DB2USERS.

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/start/t0011930.htm

8) Why get 'server closed the connection unexpectedly...' when migrate to PostgreSQL?

Please try to set the ssl_renegotiation_limit to 0, made certain ssl was off and set statement_timeout to 0 in PostgreSQL.conf, then restart the server.

9) Where is the migration log?

Migration messages are logged in [Application_Folder]\Log folder with a timestamp as file name.

10) "This application has failed to start because the application configuration is incorrect." on Windows XP.

Please install if is:
1. non-SP1: Microsoft Visual C++ 2005 Redistributable Package (x86)
2. SP1: Microsoft Visual C++ 2005 SP1 Redistributable Package (x86)

11) "Object or provider is not capable of performing requested operation." error when migrating Paradox/dBase.

This problem occurred when the current account have not enough permissions to access(read/write) the target folder. To resolve this problem:
Option 1. Run ESF Database Migration Toolkit as Administration.
Option 2. Add read/write permissions for the current account account in the target folder.

12) Got "[80040E30] Type name is invalid" error.

Please installing MDAC 2.8 http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&displaylang=en

13) Got "String or binary data would be truncated." error while migrating to SQL Server.

Solution:
In the "Data Type" page of "Setting" dialog:
Chekcing "Transfer To National Type", "CHAR -> NCHAR", "VARCHAR -> NVARCHAR" options.

14) ORA-12705 : Cannot access NLS data files or invalid environment specified.

Solutions 1:
Please remove NLS_LANG from registray. HKLM\Software\Oracle\KEY_OracleXXX_homeX\NLS_LANG.

Solutions 2:
Setting the NLS_LANG environment parameter in command line and running this program.

15) How to connect to Informix database?

Please visit: http://www.easyfrom.net/articles/connect_to_informix/

16) Why get garbled after migrated from FireBird/InterBase?

This problem occurred while FireBird/InterBase database with NONE character-set. You have to choose the correctly character-set in "Choose a Data Source" page.

17) "Unexpected error from external database driver (11265)" when migrating Paradox/dBase tables.

This problem occurrs when you have not enough permissions to access(read/write) the target folder.

To resolve this problem:
Option 1. Run ESF Database Migration Tookkit as Administration.
Option 2. Add read/write permissions for current logon account in the target folder.

18) How to connect to Oracle Server?

If tnsnames.ora containts below definition:

ESF =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.173)(PORT = 1523))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = ESF)
)
)

Then put below connection information in ESF:
.......................
Server: 192.168.1.173
Port: 1523
UserName: Your_User_name
Password: Your_Password
Database: SID ESF
......................

If tnsnames.ora containts below definition:

ESF> =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.173)(PORT = 1523))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ESF)
)
)

Then put below connection information in ESF:
.......................
Server: 192.168.1.173
Port: 1523
UserName: Your_User_name
Password: Your_Password
Database: SERVICE_NAME ESF
......................

19) [0x8004005] Invalid connection string attribute.

When you connect to SQL Server may cause this problem.

Solution:

In "Host" field, change "server name" to "server name\". e.g.: "localhost\" or "127.0.0.1\"

20) General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x80c Thread 0xdf4 DBC 0xcca0ac Text'.

Cause:
The account that is being used to access the page does not have access to the HKEY_LOCAL_MACHINE\SOFTWARE\ODBC registry key.

Resolution:
1. Start Registry Editor (Regedt32.exe).
2. Select the following key in the registry:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC
3. On the Security menu, click Permissions.
4. Type the required permissions for the account that is accessing the Web page.
5. Quit Registry Editor.

21) Why get "ORA-12560: TNS:Protocol adapter error." when connect to oracle server?

1. Make sure that Oracle TNSListener is running.

2. Put the correctly Oracle Service Name/SID in "Database" field.

22) Cannot create a row of size XXXXX which is greater than the allowable maximum of 8060.

In SQL Server 2000, this error message indicates that you have variable
length columns in your table (such as nvarchar or varbinary) and that the
total maximum length of all the columns adds up to more than 8060 bytes. You
can still insert rows into the table provided that the total length of the
data in each row does not exceed 8060 bytes. However, if the data does
exceed 8060 bytes, the insertion fails.

To resolve this problem: in "Select Tables&Views" Page, click "Transform" button, select
"Overwrite Table" option, find out which field's size is larger that 8060, and change its data type to text or image(for Blob data).

Others:
In SQL Server 2005 or above supporing row size large than 8060 bytes.

23) Duplicate key value/entry error?

This problem maybe occur when converting an auto_increment or serial field data. ESF Database Migration Toolkit copies all fields' data(auto_increment or serial values also) default, but when destination table has existed and the target field has an unique constraint, then maybe occur "Duplicate key value/entry" error.
Solutions: Uncheck "Transfer auto-increment" in "Settings" for all tables or in "Transfrom" for selected table.

24) How to speed up your conversion?

In "Setting" dialog, you can adjust "Fetch Size" and "Batch Insert" value to speed up your conversion.

i.e: Fetch Size=10000 and Batch Insert=1000, it tells program read 10000 rows for each query and batch insert 1000 rows for each query.

25) Why data display as '?' after transfered to MySQL?

You need to choose a character-set for MySQL in "Choose a Destination" page, i.e: UTF8.

26) Why "MySQL server has gone away"?

ESF Database Migration Toolkit batch insert 50 records each time, this problem will occur when the insert statement data too long(e.g.: table has a LONGBLOB field which include image data).

Solutions:
1. Set a smaller "Batch Insert" size in "Setting" dialog.

2. Modify "my.ini" to resolved it. Set "max_allowed_packet" to a larger value(e.g. 128M) e.g.: "max_allowed_packet=128M" then restart MySQL server.

3. Run "SET GLOBAL max_allowed_packet=128*1024*1024" in MySQL console. This command requires super privilleges.

27) Why appeared "Object was open" error?

Please upgrade MDAC(Microsoft Data Access Components) to 2.8.

28) How to specify schema name for PostgreSQL?

In Choose a Data Source/Choose a Destination page, input DATABASE_NAME.SCHEMA_NAME in 'Database' field to specify the database and its schema. If you specify DATABASE_NAME only, the default schema is 'public'.

29) Connects SQL Server Express 2005 failed.

Try to replace localhost with localhost\sqlexpress in "Server" field.
If using Standard(TCP/IP MODE), you want to change port from 1433 to 1284(SQL Server 2005 default port).

30) Why get ORA-32101 or ORA-32104 when creating environment?

Please download and install Oracle Instant Client for ESF Database Migration Toolkit

31) How to setup FireBird/InterBase database connection?

For a local FireBird/InterBase database, just put the file path in the "Database" box.

To connect to a FireBird/InterBase database on a remote server using TCP/IP the syntax is:
1. <server name>/server_port:<db_file>. The default firebird port is 3050.
2. <server name>/service_name:<db_file>. The default firebird service name is gds_db.

To connect to a FireBird/InterBase database on a remote server using NetBEUI, the syntax is:
\\<server name>\<filename>.

To connect to a FireBird/InterBase database on a remote server using SPX, the syntax is:
<server name>@<filename>.

32) Why appears "Can't connect to host or database" message?

1. Make sure you have installed Microsoft MDAC 2.8.
When you installing MDAC 2.8 in WinXP SP2, you will get a error message, please view here to get how to install it in WinXP SP2.
2. Check the Username & Password are correctly.
3. Do you behind a firewall? Shutdown firewall then try again.

33) How to running command line?

Job & CommandLine only support in Professional Version. Below is the usage:
<AppPath>ESFDBCV <Job_File_Path> [--log Log_File_Path]. Please view help manual to learn how to create a job file.

34) How to converts

"Excel sheet name" or "Text file name" will be converted as table name, the first row of them will be converted as field name, and from the 2nd rows will be as records. So if you want to converting "Excel sheet" or "Text file" to others database, you must define the first row for them. The structure like:
R1 | filed1 field2 field3 ... <= Be converted as target table fields.
R2 | data   data   data ... <= The 2nd row will be the 1st record of the target table
R3 | data   data   data ...
...

35) Convert to mySQL 3.x error?

When you want to convert to mySQL 3.x, please select "----" for CharacterSet DropList in the destination page.