Microsoft KB Archive/106134

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

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.