EasyFrom Inc
 

Frequently Asked Questions

Here is the knowledgebase for the program. If you can not find any solutions for your questions in here, please feel free to contact with us.
  1. Why "MySQL server has gone away"?
  2. Why appeared "Object was open" error?
  3. How to specify schema name for PostgreSQL?
  4. Connects SQL Server Express 2005 failed.
  5. Why get ORA-32101 When creating environment?
  6. How to connect FireBird/InterBase database?
  7. Why appears "Can't connect to host or database" message?
  8. How to running command line?
  9. How to converts "Excel sheet" or "Text file" to others database?
  10. Convert to mySQL 3.x error?

(1) Why "MySQL server has gone away"?

ESF Database Convert batch insert 100 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).
You can modify "my.ini" to resolved it. Set "max_allowed_packet" to a more large value e.g.: "max_allowed_packet=128M" then restart MySQL server.

(2) Why appeared "Object was open" error?

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

(3) 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'.

(4) 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).

(5) Why get ORA-32101 When creating environment?

Download Oracle Instance Client 10.1.0.5 and unzip oraociei10.dll to system directory(e.g. c:\windows\system32).

(6) How to connect FireBird/InterBase database?

For local InterBase databases, this can be a file name.

To connect to an InterBase database on a remote server using TCP/IP the syntax is:
<server name>:<filename>.

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

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

(7) 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 tries again.

(8) 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.

(9) How to converts "Excel sheet" or "Text file" to others database?

"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 ...
...

(10) Convert to mySQL 3.x error?

When you want to convert to mySQL 3.x, please select "----" for CharacterSet DropList in the destination page.
Common Links
Copyright © 2004-2008 EasyFrom Inc. All rights reserved. Privacy