asked on

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

ASKER CERTIFIED SOLUTION

SteveGTR

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

CleanupPing

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.

SteveGTR

My response gives a possible answer.

holy3daps

ASKER

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.