Error 89 Insuff. ISAM buffers

MagAero Systems · Joined: 04 Oct 2007 Posts: 8

I've got a specialised point of sale program that sometimes gives an error 89
Insufficient ISAM Buffers error message when creating reports from the ISAM
databases in VB DOS 1.0 Professional. By increasing the /I Mad

x parameter when I
compile to 75 the errors have mostly stopped. Documentation is sparse in the
manual, but how high can I increase this parameter without causing other
problems, and where might the impact be if it's too high?

Thanks in advance for the help.

Mike

Archived from group: microsoft>public>vb>dos

Ethan Winer · Joined: 04 Oct 2007 Posts: 30

Mike,

> I've got a specialised point of sale program that sometimes gives an error
> 89
> Insufficient ISAM Buffers error message

I've never used ISAM, but I wonder if it's simply a lack of memory. What
does SETMEM report as being free before and after you open the ISAM file?

--Ethan

ArarghMail703NOSPAM · Joined: 04 Oct 2007 Posts: 1

On Thu, 22 Mar 2007 11:56:57 -0400, "Ethan Winer" ethanwiner dot com> wrote:

>Mike,
>
>> I've got a specialised point of sale program that sometimes gives an error
>> 89
>> Insufficient ISAM Buffers error message
>
>I've never used ISAM,
Wise choice. Smile

>but I wonder if it's simply a lack of memory. What
>does SETMEM report as being free before and after you open the ISAM file?

ISAM was always something of a memory hog. I always used standalone
Btrieve, instead.

From PDS 7.1 help:

ISAM Use of Expanded Memory
By default, the ISAM memory-resident programs use up to approximately
1.2 Mb of expanded memory for buffer space. This frees significant
conventional memory and improves ISAM performance, as expanded memory
provides more buffers than could exist in conventional memory. ISAM's
use of expanded memory can affect how other programs, such as QBX,
utilize expanded memory. To limit ISAM's use of expanded memory, use
the /Ie option:

--
ArarghMail703 at [drop the 'http://www.' from ->] http://www.arargh.com
BCET Basic Compiler Page: http://www.arargh.com/basic/index.html

To reply by email, remove the extra stuff from the reply address.

MagAero Systems · Joined: 04 Oct 2007 Posts: 8

To make this all a bit more challenging, I have never been able to duplicate
the problem on any of my computers, even using the databases from the computers
having the problem. It always seems to be on a computer that's three or four
hundred miles away, so it's not practical to sit at the computer having the
error.

I have determined that the error will occur both in a Windows98SE window, or if
I restart in pure DOS. It also doesn't seem to happen every time,
either!

Increasing the /I Mad

x setting when I compile seems to solve the problem, but my
main concern is if I am getting close to impacting something else if I set that
too high.

I have run the Isamrepr.exe utility on the databases, but it didn't make any
difference.

Thanks,

Mike
##

In article ,
ArarghMail703NOSPAM@NOT.AT.Arargh.com says...
>
>On Thu, 22 Mar 2007 11:56:57 -0400, "Ethan Winer" >ethanwiner dot com> wrote:
>
>>Mike,
>>
>>> I've got a specialised point of sale program that sometimes gives an error
>>> 89
>>> Insufficient ISAM Buffers error message
>>
>>I've never used ISAM,
>Wise choice. Smile

>
>>but I wonder if it's simply a lack of memory. What
>>does SETMEM report as being free before and after you open the ISAM file?
>
>ISAM was always something of a memory hog. I always used standalone
>Btrieve, instead.
>
>From PDS 7.1 help:
>
>ISAM Use of Expanded Memory
>By default, the ISAM memory-resident programs use up to approximately
>1.2 Mb of expanded memory for buffer space. This frees significant
>conventional memory and improves ISAM performance, as expanded memory
>provides more buffers than could exist in conventional memory. ISAM's
>use of expanded memory can affect how other programs, such as QBX,
>utilize expanded memory. To limit ISAM's use of expanded memory, use
>the /Ie option:
>
>--
>ArarghMail703 at [drop the 'http://www.' from ->] http://www.arargh.com
>BCET Basic Compiler Page: http://www.arargh.com/basic/index.html
>
>To reply by email, remove the extra stuff from the reply address.

Dan Barclay · Joined: 04 Oct 2007 Posts: 328

> ISAM was always something of a memory hog. I always used standalone
> Btrieve, instead.

Yup, me too. Btrieve was cross platform as well. Heck, I'm still using the
same code in Win32 that I was using in DOS with just a change in
declaration.

Dan

wrote in message @4ax.com...
> On Thu, 22 Mar 2007 11:56:57 -0400, "Ethan Winer" > ethanwiner dot com> wrote:
>
>>Mike,
>>
>>> I've got a specialised point of sale program that sometimes gives an
>>> error
>>> 89
>>> Insufficient ISAM Buffers error message
>>
>>I've never used ISAM,
> Wise choice. Smile

>
>>but I wonder if it's simply a lack of memory. What
>>does SETMEM report as being free before and after you open the ISAM file?
>
> ISAM was always something of a memory hog. I always used standalone
> Btrieve, instead.
>
> From PDS 7.1 help:
>
> ISAM Use of Expanded Memory
> By default, the ISAM memory-resident programs use up to approximately
> 1.2 Mb of expanded memory for buffer space. This frees significant
> conventional memory and improves ISAM performance, as expanded memory
> provides more buffers than could exist in conventional memory. ISAM's
> use of expanded memory can affect how other programs, such as QBX,
> utilize expanded memory. To limit ISAM's use of expanded memory, use
> the /Ie option:
>
> --
> ArarghMail703 at [drop the 'http://www.' from ->] http://www.arargh.com
> BCET Basic Compiler Page: http://www.arargh.com/basic/index.html
>
> To reply by email, remove the extra stuff from the reply address.

Insufficient ISAM Buffers in VBDOS I'm getting an "Insufficient ISAM Buffers" msg in a point of sale program I have written when creating an ISAM report file of sales activities from an ISAM database containing all of thge sales data. I've optimized everything as much as I can, and can't c

Could not find Installable ISAM error hi All, I am struggling because of a major problem "Could not find Installable ISAM error". I am working on a project which is using MSAcess 2003 and VB. Earlier our application was working fine and I was having no problem in debugging the problem. But su

Streaming Buffers in VB.NET I am trying to build an application using DirectX 9 and VB.NET. I have small sounds playing well but I need to change from using static buffers to streaming buffers and I am completely confused by what is needed. There seem to be very few samples (none I

how to mix buffers to stereo wave file in DX Hi, I have written a program in DX7 and VB6 that is basically a drum machine. I have everything working great. It works perfect- except you cannot 'mix' or 'render' a final stereo wave file. I have been working on this for over a year, and any help would

Could not find installable ISAM Hello again. I am having a problem with VB and a run time error. The error says "'Run-time error 3170': Could not find installable ISAM." I am trying to link an excel file and a access database and for some reason I cannot get rid of this error. I hav