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.
