ArcGIS Server Banner

Setting up a direct connection to Informix

Setting up a direct connection to Informix

Release 9.3 E-mail This TopicPrintable VersionGive Us feedback

About connecting directly to Informix

To make a direct connection to an Informix database, you must install the Informix Client SDK or IConnect on the client machine and set up an ODBC driver.

How to set up clients

  1. Install the Informix Client SDK or the IConnect application on each remote client machine you want to connect directly to your database.
  2. This makes the Informix client setup files you need available to you. Consult your Informix documentation for further information or help on how to install these applications.

    If the Informix server is running on the same host as the client application, you can skip this step.

  3. Be sure that the user on each client machine you want to connect directly to your database has the Connect permission on the database server.
  4. Set up an ODBC driver connection.
  5. For Windows

    Use SetNet32 to configure the client so that it can work with the available objects. Also use SetNet32 to add a new Informix server.

    For UNIX

    Set up the $INFORMIXDIR and add the appropriate database server entry in the sqlhosts file in the $INFORMIXDIR\etc directory.

    Consult your Informix documentation for further information or details on how to set the ODBC driver connection.

  6. Test the connection by adding a spatial database connection from ArcCatalog. Instructions for this can be found in the topic Creating spatial database connections in the "Data management with ArcCatalog" section of the help.

Tip

  • If you are using ArcSDE 8.3 or lower, set the SDEHOME environment variable to point to the directory where the client application's dynamically linked library (.DLL) files are stored.

See Also

  • Setting up clients for a direct connection
  • Properties of a direct connection to an ArcSDE geodatabase