Solved

Unable to write to file buffer?

Posted on 2001-08-22
4
1,121 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
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.
Viewers will learn how the fundamental information of how to create a table.

756 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