Unable to write to file buffer?

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
holy3dapsAsked:
Who is Participating?
 
SteveGTRCommented:
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
 
CleanupPingCommented:
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
 
SteveGTRCommented:
My response gives a possible answer.
0
 
holy3dapsAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.