Interbase 5.6 - "Insufficient memory for this operation error" from web page

Posted on 2006-05-19
Last Modified: 2013-12-09
If I could give a 1,000,000 points for a resolution to this problem, I would without hesitation. I have this web based application running on IIS 4.0 connecting to an Interbase 5.6 database on a seperate server. Users accessing the web pages will frequently get a SQL Error Handler error every 15-20 minutes throughout the entire day and night. Error reads:

An error has occurred while performing a database request!
Message 1: Insufficient memory for this operation.
Message 2: Alias: EdmDb
Category: 37
Error Code: 9473
SubCode: 1
Native Error: 0
Sql String: Select location...blah blah

Other times, users will get an "Internal Server Error" and that's it. Random, not tied to any specific time of the day or high/low periods of usage. The only way I can resolve the issue is to restart the www publishing services on the web server. I even setup a job to restart that service every 15 minutes, and that still doesn't help out with this problem. Talking to the vendor is useless as they say this is a bug on Interbase. I think that's cr@p and there has to be a fix to this. Can anyone, anyone help with this problem, PLEASE?!? If I have to create fake questions to give you 1,000,000 million points, I'll do it...that's how desparate I am!  =)
Question by:itagent007
    LVL 6

    Expert Comment

    How big your database?
    Can you give me the hardware information of your database server box ?
    How does your web application connect IB database? (ADO, ODBC,...or through a middle layer)

    LVL 19

    Accepted Solution

    is this relevant,1410,15329,00.html

    I would upgrade what is a VERY old version either from borland (interbase 7.5) or firebird (free, open-source, download from

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
    APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now