Microsoft KB Archive/115923

{|
 * width="100%"|

BUG: bcp_done Sets TEXTSIZE to 4096

 * }

Q115923

-

The information in this article applies to:


 * Microsoft SQL Server Programmer's Toolkit, version 4.2

-

BUG# 10040 (4.2)

SYMPTOMS
The DB-Library (DB-Lib) bcp_done function will set the DBTEXTSIZE option to 4096 for the current DBPROCESS. Any prior setting of this option will be overridden by bcp_done.

CAUSE
The bcp_done function sends a SET TEXTSIZE 4096 statement to SQL Server as part of its internal housekeeping.

WORKAROUND
Reset the DB-Library DBTEXTSIZE option to the desired value after completing a bcp operation if you will reuse the same DBPROCESS connection.

STATUS
Microsoft has confirmed this to be a problem in DB-Library 4.20.00. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: dblib

Keywords : kbtool

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbSQLServPTK420