Caractéristiques du Programme

Voici l'encyclopédie d'information pour le programme. Si vous ne pouvez trouver aucune solution à vos questions ici, sentez-vous libres de nous contacter.
  1. Got "String or binary data would be truncated." error while migrating to SQL Server.
  2. ORA-12705 : Cannot access NLS data files or invalid environment specified.
  3. How to connect to Informix database?
  4. What are reqirements when migration from/to IBM DB2?
  5. Why get "Error: 1017 Ora-00000 ..." error?
  6. Why get garbled after migrated from FireBird/InterBase?
  7. Unexpected error from external database driver (11265) while migrating Paradox/dBase tables.
  8. How to connect to Oracle Server?
  9. [0x8004005] Invalid connection string attribute.
  10. General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x80c Thread 0xdf4 DBC 0xcca0ac Text'.
  11. Why get "ORA-12560: TNS:Protocol adapter error." when connect to oracle server?
  12. Cannot create a row of size XXXXX which is greater than the allowable maximum of 8060.
  13. Duplicate key value/entry error?
  14. How to speed up your conversion?
  15. Why data display as '?' after transfered to MySQL?
  16. Why "MySQL server has gone away"?
  17. Why appeared "Object was open" error?
  18. How to specify schema name for PostgreSQL?
  19. Connects SQL Server Express 2005 failed.
  20. Why get ORA-32101 or ORA-32104 when creating environment?
  21. How to connect FireBird/InterBase database?
  22. Why appears "Can't connect to host or database" message?
  23. How to running command line?
  24. How to converts
  25. Convert to mySQL 3.x error?

1) 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.

2) 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.

3) How to connect to Informix database?

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

4) What are reqirements when migration from/to IBM DB2?

1. Installed IBM OLE DB Provider for DB2.

2. If you DB2 is v8.x or lower, installing IBM DB2 FixPacks also.

5) Why get "Error: 1017 Ora-00000 ..." error?

Please check the parameter REMOTE_LOGIN_PASSWORDFILE, this value should be EXCLUSIVE, otherwise you cannot logon remotely as sysdba.

Bellow links are about this parameter:
http://www.oracleutilities.com/OSUtil/orapwd.html
http://it.toolbox.com/wiki/index.php/Remote_login_as_Sysdba_to_Oracle_database_server

6) 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.

7) Unexpected error from external database driver (11265) while 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 Took as Administration
Option 2. Add read/write permissions for current logon account in the target folder.

8) How to connect to Oracle Server?

If tnsnames.ora containts below definition
Begin >>>>>>>>>>>>>>>>>>

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

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
Begin >>>>>>>>>>>>>>>>>>

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

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

9) [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\"

10) 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.

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

1. Make sure that Oracle TNSListener is started.

2. Install Oracle Instant Client for ESF Database Migration Toolkit

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

12) 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.

13) 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.

14) 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.

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

You want to choose a character-set for MySQL in "Choose a Destination" page, i.e: UTF8 or a character-set which supporting your localtion characters.

16) 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.

17) Why appeared "Object was open" error?

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

18) 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'.

19) 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).

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

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

21) 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>.

22) 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.

23) 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.

24) 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 ...
...

25) Convert to mySQL 3.x error?

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