Home | Previous Page | Next Page   Appendix F. SQLHOSTS Registry Key (Windows) > Preparing the SQLHOSTS Connectivity Information >

Setting up the SQLHOSTS Registry Key with regedt32

It is recommended that you use ISA to set up the SQLHOSTS registry key.

Important:
Use extreme caution with regedt32. If you make mistakes when editing the registry, you can destroy the configurations, not only of your IBM Informix products, but of your other applications.
To set up SQLHOSTS with regedt32
  1. Run the Windows program, regedt32.
  2. In the Registry Editor window, select the window for the HKEY_LOCAL_MACHINE subtree.
  3. Click the folder icons to select the \SOFTWARE\INFORMIX\ SQLHOSTS branch.
  4. With the SQLHOSTS key selected, choose Edit > Add Key.
  5. In the Add Key dialog box, type the name of the database server in the Key Name dialog box.

    Leave the Class dialog box blank. Click OK.

  6. Select the new key that you just made (the key with the database server name).
  7. Choose Edit > Add Value.
  8. In the Add Value dialog box, type one of the fields of the sqlhosts information (HOST, OPTIONS, PROTOCOL, SERVICE) in the Value Name dialog box.

    Do not change the Data Type box. Click OK.

  9. In the String Editor dialog box, type the value for the field that you selected and click OK.
  10. Repeat steps 8 and 9 for each field of the sqlhosts information.

Figure 24 illustrates the location and contents of the SQLHOSTS registry key.

Figure 24. sqlhosts Information in the Windows Registry
begin figure description - This figure is described in the surrounding text. - end figure description
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]