1 (888) 569-7711
Toll-Free:

ODBC Driver: Informix

Informix Driver Installation

To set up an Informix DSN you will first need the following information from your IT department (or request you IT department’s help with this process):

Next we will install the Informix client and set up the ODBC DSN. This portion of the setup is fairly technical, so if you are unsure of anything please contact your IT department:

  1. 1.Install the Informix client. This is a licensed product from Informix that should have been provided as part of your Informix installation. Generally it is available on CD, or as a file distributed on your network.
  2. Place the CD in your CD drive, and explore the CD.
  3. Find the setup.exe program: [CD Drive] \ICONNECT\WIN_NT95\Setup.exe (or similar)
  4. Run this program (double click on it). Follow the steps on screen:

    Welcome

    Installer
  5. Click Next.

    Enter Serial # and Key

    Installer
  6. Click Next.

    User Information

    Installer
  7. Click Next.

    Choose Destination Location

    Installer
  8. Click Next.

    Setup Type

    Installer
  9. Click Next.

    Select Program Folder

    Installer
  10. Click Next.

    Start Copying Files

    Installer
  11. Click Next.

    Setup Complete

    Installer
  12. Once the Intaller has Finished, Click Finish.
  13. The Informix Connect Drivers should now be installed

Next we need to do some setup on your computer.

  1. Locate the Hosts file in c:\windows\system32\drivers\etc or c:\winnt\system32\drivers\etc and add this line:
    xxx.xxx.xxx.xxx DNSHostName
    Where xxx.xxx.xxx.xxx is the IP Address of your Pentamation Host, and DNSHostName is the DNS name of your Pentamation Host machine.
  2. Locate the Services file in c:\windows\system32\drivers\etc or c:\winnt\system32\drivers\etc and add this line:
    sqlexec 1525/tcp
  3. The Informix Connect install places a SETNET32 utility in the Start/Programs menu. Click the shortcut to run SETNET32 and ensure these parameters are set:
  4. On the Environment tab:
    • INFORMIXDIR=/c:\Informix/
      This is the installation folder of the Informix client.
    • INFORMIXSERVER=/xsrvr/
      This is the name of the Informix server on the host (this may be different if you have a different server name enter it here) DBPATH=//stubase/schdata/
      This is the DBPATH of the Host’s Pentamation student database (again this may be different, if you are having trouble finding this value log on to the server and display the DBPATH this should be the same)
  5. On the Server Information tab:
    • Informix Server: /xsrvr/
      Same as INFORMIXSERVER above.
    • Host name: /DNSHostName/
      Same as DNSHostName that was set in the Hosts file in step 2.
    • Protocol: sesoctcp
    • ServiceName: sqlexec
  6. Now Click Make Default Server
  7. On the Host Information tab:
    • User name: Set with a valid Pentamation ID that has access rights to extract data.
    • Password: Ask Password at runtime.
  8. Close the SETNET32 utility.

Contact support

Toll Free
1 (888) 569-7711
Support hours
Monday-Friday
8:30AM - 3:00PM PST
Start a support request
By email