The sqlhosts information in a Windows environment

The registry contains the following connection information:

• The sqlhosts information defines a connection to an established database server.

  This information includes the name of the host computer, the type of protocol to use, and the name of the connection. The Registry stores the sqlhosts information in the SqlHosts subkey of the HCL OneDB™ key. To store sqlhosts information in the Registry, use the Server Information tab of the Setnet32 utility.

• The .netrc information defines a valid user for a remote connection.

  On UNIX™ operating systems, this file is in the home directory of the user and specifies the name and password for the user account. In Windows™ environments, the NETRC subkey of the HCL OneDB key in the Registry stores the same account information. To store .netrc information in the Registry, use the Host Information tab of the Setnet32 utility.

The client sends network parameters to establish a connection to a database server. The first step in establishing a connection is to log on to the correct host computer. The protocol software uses the network parameters for the current database server. The client locates the network parameters for the current database server in either of the following ways:

1. If the SQL statement that requests the connection (such as a CONNECT or DATABASE) specifies the name of a database server, the client sends the network parameters for this specified database server.

   If the InfxServer field of InetLogin contains the name of the specified database server, the client checks InetLogin for the network parameters. Otherwise, the client obtains network parameters for that database server from the in-memory copy of the Registry.

2. If the SQL statement does not specify a database server, the client sends the network parameters for the default database server.

   If the InfxServer field of InetLogin contains the name of a database server, the client checks InetLogin for the network parameters. Otherwise, the client determines the default database server from the ONEDB_SERVER value in the in-memory copy of the Registry. It then sends network parameter values from the Registry for that database server.

For example, the following code fragment initializes the InetLogin structure with information for the mainsrvr database server; mainsrvr is the default database server.

void *cnctHndl;
;

strcpy(InetLogin.InfxServer, "mainsrvr");
strcpy(InetLogin.User, "finance");
strcpy(InetLogin.Password, "in2money");
EXEC SQL connect to 'accounts';
;

QL connect to 'custhist@bcksrvr';

When execution reaches the first CONNECT statement in the preceding code fragment, the client application requests a connection to the accounts database on the mainsrvr database server. The CONNECT statement does not specify a database server, so the client sends the following network parameters for default database server:

• The default database server is mainsrvr because InfxServer is set in InetLogin.
• The User and Password values are finance and in2money because the application sets them in InetLogin.
• The Host, Service, Protocol, and AskPassAtConnect values are from the mainsrvr subkey of the Registry values, because the application does not set them in InetLogin.