1 (888) 569-7711
Toll-Free:

ODBC Set-Up: Informix

To set up an Informix DSN:

  1. Open the Windows Data Sources (ODBC) control panel:
    1. From the Start menu, choose Control Panel.
    2. On Windows 2000/XP, open the Administrative Tools folder.
    3. Double-click the Data Sources (ODBC) icon.
  2. This will open the ODBC Data Source Administrator:

    3. Create New Data Source

    Create Data Source
  3. On the System DSN tab, click the Add… button.

    4. Choose Driver

    Create Data Source
  4. From the list of drivers that appears, choose INFORMIX [version] 32 BIT, and click Finish.
  5. Informix ODBC Driver Setup screen will appear.

    6. Informix ODBC Driver Setup

    Informix ODBC Driver Setup
  6. On the General tab: Enter the Data Source Name, enter a name for the data source. Remember the name you choose, it is the same name you should enter in the Pentamation Open Series and Student Plus DSN box in the Extractor.
  7. Click on the Connection tab:

    Connection Settings

    Connection Settings
    • Server Name: /xsrvr/ Same as INFORMIXSERVER in step 4. (should be populated already)
    • Host name: DNSHostName Same as DNSHostName in step 2.
    • Service: sqlexec (should be populated already)
    • Protocol: sesoctcp (should be populated already)
    • Database: /studentDBName/ Name of the Pentamation student database.
    • User Id: Valid Pentamation ID
    • Password: password for the above ID
  8. Click Apply & Test Connection
  9. Click OK.

Contact support

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