Solved

Unable to write to file buffer?

Posted on 2001-08-22
4
1,113 Views
Last Modified: 2011-04-14
I am using SQL Server 7 (SP3) to support a database and am accessing it through an MFC-based front-end. The operating system is Windows NT 4 Server (SP6). I am running into a problem where:

A. A CDBException is thrown during a CRecordset::MoveNext
call giving the following error:

"General Error: Unable to write to file buffer"

B. Consequently, SQL Server Enterprise Manager will refuse to launch

C. Enterprise Manager will only launch if the system is rebooted.

D. The error seems to occur after some number of accesses to the database

E. The only accesses I am doing are opening (CRecordset::Open) and moving through the records (CRecordset::MoveFirst, CRecordset::MoveNext).

This is driving me nuts.

:)

Hope you can help.

Thanks!

Sincerely,

karl g. kowalski
killer@alum.mit.edu
holy3daps@yahoo.com
0
Comment
Question by:holy3daps
  • 2
4 Comments
 
LVL 30

Accepted Solution

by:
SteveGTR earned 200 total points
ID: 6417933
How much memory is installed on your server? The reason I ask is Q115516 refers to your error. The only thing is that it applies to client machine and it sounds like your server has the problem. Here is the resolution notes:

-----
RESOLUTION
To avoid the error, 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: On Windows NT calling SetHandleCount() 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 specified by the TEMP environment variable or the current working directory.
-----

Good Luck,
Steve
0
 

Expert Comment

by:CleanupPing
ID: 9281738
holy3daps:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
 
LVL 30

Expert Comment

by:SteveGTR
ID: 9282000
My response gives a possible answer.
0
 

Author Comment

by:holy3daps
ID: 9283127
To SteveGTR - thanks for the help. I apologize for taking so long to respond. In case you're curious, here's what had happened: I was neglecting to call the CDBRecordset::Close() method, which was causing the issues; once I started doing this in all my Recordset objects, the problem went away.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question