VerifyServerName Communication Parameter [Verify]

The VerifyServerName Communication Parameter specifies whether the server name is verified when connecting to this host.

Usage

TCP/IP (Client side only)

Values

YES, NO

Default

YES

Description

Normally, you should not set this option. It is used only for connecting to multiplex secondary servers to balance query loads among these servers.

When connecting over TCP using the DoBroadcast=NONE parameter, the client makes a TCP connection, then verifies that the name of the server found is the same as the one it is looking for. Specifying VerifyServerName=NO skips the verification of the server name. This allows IQ clients to connect to a SAP Sybase IQ server if they know only an IP address/port.

The server name must still be specified in the connection string, but it is ignored. The VerifyServerName (VERIFY) communication parameter is used only if DoBroadcast=NONE is specified.

When used as shown in the example, setting this option to NO lets you specify a connection to a particular IP address and port number. The IP address and port number are for a load balancing machine that acts as a gateway between the IQ client and the IQ server.

Example

To use this option, on the client machine, create a new ODBC DSN in the ODBC Administrator, and specify parameters as follows:

On the Database tab, specify a generic server name for connecting to all of the secondary servers, for example, qserv. A server name is required, but ignored because of parameters in the Network tab.
On the Network tab, select the TCP/IP check box and type in the text box:
```
host=hostname;port=port#;DOBROADCAST=NONE;VERIFY=NO
```
For example:
```
host=hostname;port=2222;DOBROADCAST=NONE;VERIFY=NO
```

When an IQ client connects to this DSN, the load balancer dispatches the connection to a particular secondary server based on the workload of the machine.