The ODBC section of the odbc.ini file must specify UNICODE=UCS-2. Caching prepared statements on the client side substantially improves performance on highly used statements.The CursorBehavior value must be 1 so that cursors are preserved beyond transaction boundaries.Replace with the name of your Informix server as specified in the INFORMIXSQLHOSTS file.The database name can differ from the data source name. Replace with the name of the Informix database for which you are creating the data source name.Each data source name in the odbc.ini file must be unique. You need a data source name for each database or geodatabase to which you want to connect. Replace with the name you want to use.These are the values to include in the file: You will reference this file and location in the init_user_param.sh script so ArcGIS for Server can find it. When configuring for use with ArcGIS for Server, place the file in a directory to which the ArcGIS Server administrator account has at least read access. You can configure an ODBC data source name by creating a file named odbc.ini on the computer where ArcGIS is installed and populating the file with connection information.
#Informix odbc caching update#
You can update the data sources by clicking the Configure button on this dialog box. The data source you create appears in the System Data Sources list on the System DSN tab of the ODBC Data Source Administrator dialog box.
#Informix odbc caching driver#
Click OK to exit the Informix ODBC Driver Setup dialog box.Setting the Cursor Behavior to 0 - Close will have undesirable effects during data insertions and updates. Cursor Behavior must be set to 1 - Preserve because ArcGIS expects Informix cursors to remain open and active following a database COMMIT operation. Informix ODBC Driver Guide - IBM These topics serve as a user guide and reference for IBM® Informix® ODBC Driver, which is the Informix implementation of the Microsoft Open Database Connectivity (ODBC) interface, Version 3.0.Type the appropriate client locale in the Client Locale text box and check Use Server Database Locale to set the database locale.Type the appropriate locales in the Client Locale and Database Locale text boxes.Set the locale by doing one of the following:.Click the Environment Tab to set up the environment properties.If the connection does not succeed, correct the information provided and try again. If the connection succeeds, delete the user name and password from the User Id and Password text boxes, click Apply, then proceed to the next step.