Setting up an ODBC data source for Informix on Windows

You must set up the ODBC data source for your database prior to running the Post Installation wizard for ArcSDE for Informix. If the ODBC data source was not set when the database was created and registered with the Informix Spatial DataBlade, follow the steps in this topic to set up the ODBC data source.

You must create an ODBC data source for each database you will use for an ArcSDE geodatabase.

Steps:

1. From the Windows Start menu, open the Control Panel.
2. Double-click Administrative Tools.
3. Double-click Computer Management.
4. Double-click the Data Sources (ODBC) icon.

   The ODBC Data Source Administrator dialog box opens.

5. Click the System DSN tab.
6. Click the Add button.

   The Create New Data Source dialog box appears, displaying the list of ODBC drivers that are installed on your system.

7. Choose the IBM INFORMIX ODBC DRIVER and click Finish.

   The Informix ODBC Driver Setup dialog box opens.

8. Create the administrator's data source by typing the name of the data source in the Data Source Name text box.
9. Click the Connection Tab to proceed to set up the connection properties.
10. Choose the name of the server and database from the Server Name and Database Name drop-down lists, respectively.
11. Choose olsoctcp from the Protocol drop-down list.
12. Type the host name and service in their respective text boxes.
13. Leave the User Id and Password text boxes blank.
    Tip:

    Click Apply & Test Connection to verify that the connection parameters are set correctly.

14. Click the Environment Tab to set up the environment properties.
15. Cursor Behavior must be set to 1 - Preserve cursor because ArcSDE software expects Informix cursors to remain open and active following a database COMMIT operation.

    Setting the Cursor Behavior to 0 - Close will have undesirable effects during data insertions and updates.

16. Type the appropriate locales in Client and Database Locales.
17. Click the Advanced tab.
18. Accept the default settings for the Advanced parameters and click Apply.
19. Click OK to exit the Informix ODBC Driver Setupdialog 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. You can update the data sources by clicking the Configure button on this dialog box. However, you should never change data sources while the ArcSDE service that uses the data source is running. Always shut down the ArcSDE service first.