Configure informix odbc Data Source

Technorati label: informix odbc driver

To configure the ODBC data source, you must first download an Informix Client of Informix cli, which is actually a collection of Informix ODBC drivers and some practical tools, as follows:

Ftp://ftp.software.ibm.com/software/data/informix/downloads/connect-281-TC1-NT.zip

After the installation is complete, the Informix driver will be available on the new data source tab. You need to fill in the following fields: Server Name should be the machine Name, and then Host Name is the IP address, then there is Service. This indicates the Service Name or port number. Protocol indicates the Protocol, Database Name indicates the Database Name, and User Id and Password indicates the User Name and Password.

The Service, Protocol, and Database Name can be obtained by reading the configuration file home/informail/etc/sqlhosts.

Another problem may occur in the language, that is, the Client Locale and Database Locale of Environment. If a Localse error is reported, you should check the Use Server Database Locale, then, change the Client Locale to be the same as the Database Locale, so there is no problem.