Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Unable to write to file buffer?

Posted on 2001-08-22
4
Medium Priority
?
1,138 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 600 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

721 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