Microsoft KB Archive/101423

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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.