PRB: Error 17832 Caused by Blocking Timeout in 16-Bit Sockets

MORE INFORMATION

To avoid re-entrancy issues, the 16-bit sockets Net-Library makes socket connect calls in blocking mode. It registers its own blocking hook function, which temporarily disables Windows message dispatching, and will time out the connect call if the connect call does not return within the blocking timeout (the default is five seconds). Upon receiving error 10004 (WSAEINTR) due to the blocking timeout, DB-Library or the ODBC driver will retry the connection at incremental time intervals up to one second, until the logon timeout finally expires. However, when a socket connect call is interrupted on Windows 95, Winsock (Wsock.vxd) incorrectly returns an undocumented error -2 on all subsequent connect attempts, even though the connections are established successfully. The 16-bit Net-Library then reacts to the unrecognized error -2 by closing the socket. On the server side, SQL Server reports the Open Data Services error 17832 for each logon attempt when it tries to read from the closed connection, through which the logon packet is expected to be sent.

On a normal TCP/IP network, the default blocking timeout (five seconds) should be long enough, so socket connections are made without ever having to invoke the blocking timeout. But if for any reason you observe that SQL Server connections using the 16-bit sockets Net-Library fail frequently with operating system error -2, and a large number of error 17832s are logged on the server, you can increase the blocking timeout value to avoid the problem. Just set the MaxSecondsToBlock value under the [SQL Server] section in the Win.ini file. For example, you can use the following entry to set the blocking timeout to 20 seconds:

   [SQL Server]
   MaxSecondsToBlock=20