FIX: BCP Fails with Error Message "Not Enough Memory"
  
PSS ID Number: Q106134
Article last modified on 10-31-1994
 
4.20.50
 
MS-DOS
 

----------------------------------------------------------------------
The information in this article applies to:
 
  - Microsoft SQL Server Programmer's Toolkit, version 4.2
----------------------------------------------------------------------
 
BUG# 9522 (4.20.50)
 
SYMPTOMS
========
 
When the SQL Server Bulk Copy Program (BCP) version 4.20.50
is being used to transfer data into SQL Server from an MS-DOS
workstation, the following error may be generated:
 
   Operating-system error: not enough memory
   DB_LIBRARY error: unable to allocate sufficient memory
 
Depending on the version of MS-DOS, the operating system error might
also say:
 
   not enough core
 
CAUSE
=====
 
BCP is not correctly freeing up memory under certain conditions
and it may run out of conventional memory.
 
WORKAROUND
==========
 
If you encounter this situation, you can either run the BCP
process from an OS/2 or Windows NT SQL Server machine. An
alternate solution is to use BCP version 4.20.21.
 
STATUS
======
 
Microsoft has confirmed this to be a problem in DB-Library version 4.20.50.
This problem was corrected in DB-Library version 4.21.00. For more
information, contact your primary support provider.
 
Additional reference words: 4.20.50
KBCategory: kbtool
KBSubCategory: SSrvBCP
 
=============================================================================
 
Copyright Microsoft Corporation 1994.
