Microsoft KB Archive/114958

{|
 * width="100%"|

INFO: Improper Usage of dbclose Can Cause Disconnect Message

 * }

Q114958

-

The information in this article applies to:


 * Microsoft SQL Server Programmer's Toolkit, version 4.2

-

SUMMARY
Improper usage of the dbclose function in a DB-Library (DB-Lib) program can result in several disconnection messages written to the error log and event viewer. If a DB-Library program calls dbclose before processing of results is complete, messages 17824, 232, and 109 will appear in the SQL Server error log and the Windows NT application event log.

MORE INFORMATION
When dbclose is called after dbsqlexec and before dbresults or before all processing is complete using dbresults, the following error is logged in the NT event viewer as eventID 17058 (the error will also appear in the SQL Server error log):

Error: 17824, Severity 10, State 0

Unable to write to ListenOn connection

"\\.\pipe\sql\query',loginame 'sa',hostname''.

OS Error: 232, The pipe is being closed

The SQL server error log may contain the following entry:

kernel Cannot send, host process disconnected:

spid:

1

A properly developed DB-Library program should call dbcancel before dbclose if results do not need to be processed. Note that this behavior will appear when using DB-Library versions 4.21 or 4.20.50.

Additional query words: dbclose client 17824 232 109 dblib

Keywords : kbprogramming

Issue type : kbinfo

Technology : kbSQLServSearch kbAudDeveloper kbSQLServPTK420