Microsoft KB Archive/101423

From BetaArchive Wiki

FIX: bcp_collen Can Cause Error 10066 During bcp_moretext

PSS ID Number: Q101423 Article last modified on 01-24-1995

4.20 | 4.20 | 4.20

WINDOWS | MS-DOS | OS/2

The information in this article applies to:
- Microsoft SQL Server Programmer’s Toolkit, version 4.2

BUG# 8897 (4.2)

SYMPTOMS

Calling bcp_moretext results in DB-Library (DB-Lib) in the following error message (error 10066):

Attempt to send too much TEXT data via the bcp_moretext() call.

CAUSE

DB-Library incorrectly handles bulk copy (BCP) text and image data transfer when bcp_collen is called with a varlen parameter greater than 65535.

WORKAROUND

Use bcp_bind to adjust the varlen parameter of text and image columns.

STATUS

Microsoft has confirmed this to be a problem in DB-Library version 4.2. This problem was corrected in DB-Library 4.20.50. For more information, please contact your primary support provider.

Additional reference words: 4.20.00 dblib KBCategory: kbprg KBSubcategory: SSrvDB_Lib

=================================================================

Copyright Microsoft Corporation 1995.