You receive an "Unable to write to file buffer State:S1000" error message when you call the Open method for a CDatabase or CRecordset object in Visual C++ (115516)



The information in this article applies to:

  • The Microsoft Foundation Classes (MFC), when used with:
    • Microsoft Visual C++ for Windows, 16-bit edition 1.5
    • Microsoft Visual C++ for Windows, 16-bit edition 1.51
    • Microsoft Visual C++ for Windows, 16-bit edition 1.52
    • Microsoft Visual C++, 32-bit Editions 2.0
    • Microsoft Visual C++, 32-bit Editions 2.1
    • Microsoft Visual C++, 32-bit Editions 4.0
    • Microsoft Visual C++, 32-bit Editions 4.1
    • Microsoft Visual C++, 32-bit Enterprise Edition 4.2
    • Microsoft Visual C++, 32-bit Enterprise Edition 4.2b
    • Microsoft Visual C++, 32-bit Enterprise Edition 5.0
    • Microsoft Visual C++, 32-bit Enterprise Edition 6.0
    • Microsoft Visual C++, 32-bit Professional Edition 4.2
    • Microsoft Visual C++, 32-bit Professional Edition 4.2b
    • Microsoft Visual C++, 32-bit Professional Edition 5.0
    • Microsoft Visual C++, 32-bit Professional Edition 6.0
    • Microsoft Visual C++, 32-bit Learning Edition 6.0
    • Microsoft Visual C++ .NET (2002)
    • Microsoft Visual C++ .NET (2003)
  • Microsoft Data Access Components 2.5

This article was previously published under Q115516

SYMPTOMS

When you call the Open method for a CDatabase or CRecordset object, you receive one of the following error messages
General error: Unable to create file buffer.
State:S1000,Native:0,Origin:[Microsoft][ODBC Cursor Library]
General error: Unable to write to file buffer
State:S1000, Native:0, Origin:[Microsoft][ODBC Cursor Library]
General error: Unable to close file buffer
State:S1000, Native:0, Origin:[Microsoft][ODBC Cursor Library]

CAUSE

By default, the MFC ODBC CDatabase class loads the ODBC cursor library (16 bit: ODBCCURS.DLL, 32 bit: ODBCCR32.dll). This allows an application to define snapshot recordsets (the default) and scroll backward as well as forward through the recordset. This cursor library caches the records of a snapshot. To perform the caching, the 16-bit cursor library creates a temporary file in the directory that is specified by the TEMP environment variable or, if the TEMP variable is not defined, in the current directory. The 32-bit cursor library creates a temporary file in the current directory. A temporary file is created for each CRecordset object created. If the temporary file cannot be created, the error shown above occurs. This error most likely occurs for one of the following reasons:
  • There are not enough file handles available for the application.
  • There is not enough hard disk space available to create the file.

RESOLUTION

To avoid the error message, increase the number of available file handles for the application. This can be done by calling the Windows API function SetHandleCount. Also, increase the number specified by the "FILES=" line in the Config.sys file.

Note In Microsoft Windows NT, calling the SetHandleCount function has no effect and Windows NT ignores the Config.sys file. Windows NT limits file handles solely on the amount of available memory.

Make sure that there is plenty of disk space available in the directory that is specified by the TEMP environment variable or the current working directory.

Modification Type:MajorLast Reviewed:9/1/2005
Keywords:kbtshoot kbDatabase kbFileIO kbprb KB115516 kbAudDeveloper