BUG: bcp_done Sets TEXTSIZE to 4096

ID: 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 SSrvBCP SSrvDB_Lib SSrvProg kbbug4.20
Version : 4.2 | 4.2 | 4.2
Platform : MS-DOS OS/2 WINDOWS
Issue type :