Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/106134

From BetaArchive Wiki

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.