-- In ib-support@y..., Helen Borrie <helebor@d...> wrote:

> At 08:15 PM 01-08-01 +0100, you wrote:
>
> The SQLDA bug doesn't occur on the server side, i.e. if your SP

does multiple inserts during one call, all will work. It occurs when
the same SP is called repeatedly without being reprepared and
unprepared between calls. It is caused by a certain field in the
SQLDA structure not being reset properly between client calls.

>

Is it possible that this bug will also give rise to access violations
in gds32.dll on the client? We had exactly this problem with a SP
that did an insert. Calling the SP in rapid succession from the
client would occasionally result in access violations in gds32.dll
(client side). The work around was to prepare and unprepare the
statement between executing the SP. This, of course, leads to a
tremendous performance hit if you are trying to insert large numbers
of records.