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.
