Controlling the Connection Timeout

To avoid a connection error, increase the TcpKeepTries value.

When an isql connection remains idle for several minutes, the next query may result in this error message:

Attempt to initiate a new SQL Server operation with results pending.

This problem occurs when you use the Windows Sockets protocol, and you have a small value for Windows TcpKeepTries. To correct this problem, increase the value.

Warning! Do not modify Registry values unless you are an Windows Administrator and you are familiar with the regedt32 utility. See the Windows operating system documentation.