SQLHOSTS Registry Key (Windows)

In an Enterprise Replication environment, you manage connectivity information about Windows™ operating systems with the SQLHOST registry key.

When you install the database server, the setup program creates a key in the Windows registry:

• For an HCL OneDB™ 64-bit product installed on a Windows 64-bit system or an HCL OneDB 32-bit product installed on a Windows 32-bit system, the sqlhosts information is in this key:

  HKEY_LOCAL_MACHINE\SOFTWARE\INFORMIX\SQLHOSTS

• For an HCL OneDB 32-bit product installed on a Windows 64-bit system, the sqlhosts information is in this key:

  HKEY_CLASSES_ROOT\VirtualStore\MACHINE\SOFTWARE\Wow6432Node\Informix\SQLHOSTS

  If you have 32-bit and 64-bit HCL OneDB software (client or server) operating together on Windows on the same machine, you must have duplicate entries in both registry hives.

A branch of the HKEY_LOCAL_MACHINE subtree stores the sqlhosts information. Each key on the SQLHOSTS branch is the name of a database server. When you click the database server name, the registry displays the values of the HOST, OPTIONS, PROTOCOL, and SERVICE fields for that particular database server.

Each computer that hosts a database server or a client must include the connectivity information either in the sqlhosts registry key or in a central registry. When the client application runs on the same computer as the database server, they share a single sqlhosts registry key.