https://support.ispirer.com/ 2026-04-08T11:17:45+0000 https://support.ispirer.com/ https://support.ispirer.com/lib/tpl/bootstrap3/images/favicon.ico text/html 2025-06-03T15:39:55+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/informix/bin-directory?rev=1748965195&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Informix: Bin Directory and Utilities to Perform Import SQLWays is able to execute the import process automatically. To perform it, user should provide target database credentials and Bin Directory. Bin Directory is a path to a folder containing command line utility of the target database (like psql.exe, sqlcmd.exe, mysql.exe and others). With the help of this utility import process is performed. text/html 2023-10-25T12:52:07+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/informix/function-sequence-error?rev=1698238327&do=diff Ispirer Website Ispirer Capabilities: Informix Migration Free Trial Function Sequence Error Symptoms When there is data extraction from Informix database there might be an error specified below. [Informix ODBC Driver] Function Sequence Error. Cause An asynchronously executing function is called for the hstmt and is still executing when this function is called, or an attempt was made to use an hstmt out of sequence. For example, you are trying to execute an EXECUTE statement before the PR… text/html 2023-10-25T13:08:54+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/informix/inexact-character-conversion?rev=1698239334&do=diff Ispirer Website Ispirer Capabilities: Informix Migration Free Trial Inexact Character Conversion During Translation Symptoms While migration from Informix database there might be an error specified below: [Informix][Informix ODBC Driver]Inexact character conversion during translation. Cause This problem maybe caused by the difference in Collations used on Client and on Server where Informix is running. text/html 2025-06-03T15:39:55+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/informix/long-export-process?rev=1748965195&do=diff Ispirer Website Ispirer Capabilities: Informix Migration Free Trial Export Process Takes Much Time Symptoms When migrating from huge Informix database, it may take a lot of time to read the database structure during the export process, even if only one object specified for a conversion. Cause This situation may appear, because our tool tries to execute UPDATE STATISTICS statement for all tables and routines in the current Informix database in order to update system catalogs with the actua… text/html 2025-06-03T16:33:26+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/informix/odbc-driver-configuration?rev=1748968406&do=diff Ispirer Website Ispirer Capabilities: Informix Migration Free Trial Informix ODBC Driver Configuration To tune the ODBC Connection to Informix database, please fulfill the following steps: 1. Select the Windows Control Panel -> Administrative Tools -> Data Sources (ODBC) option. The ODBC Data Source Administrator window is displayed. text/html 2026-02-04T12:42:34+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/informix/odbc-driver-installation?rev=1770208954&do=diff Ispirer Website Ispirer Capabilities: Informix Migration Free Trial Informix ODBC Driver Installation NOTE: Informix database migration is fully supported by Ispirer SQLWays tool only with a driver version of at least 4.1. To install the ODBC driver for Informix, please follow the steps below: * First, navigate to one of the following links: text/html 2025-06-03T15:39:53+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/informix/sort-rows-inability?rev=1748965193&do=diff Ispirer Website Ispirer Capabilities: Informix Migration Free Trial Cannot Sort Rows Description When migrating from huge Informix database, during the conversion stage some tables may fail with the following error: <<<<SQLError [Informix][Informix ODBC Driver][Informix]Cannot sort rows.Execute query failed. >>>> text/html 2023-12-14T14:48:29+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/informix/source-user-privileges?rev=1702565309&do=diff Ispirer Website Ispirer Capabilities: Informix Migration Free Trial Informix: Setting up Source User Privileges To be able to connect to a database and to extract DDL of objects in Informix, you need to create a user in the operational system where the Informix server is installed. After that you need to add this user to IX_USERS group in Administrative Tools in Computer Management. Also you need to grant a connect privilege to this user, so that it can connect to this database: