SQL Error: SQLDA missing or incorrect version, or incorrect number/types of variables

[Marc van de Laar]

Hello

Sometimes when a user of our main application tries to print a report, the
following database error occurs:
SQLDA missing or incorrect version, or incorrect number/types of variables.
The errorcode of this error, according to the Interbase language reference,
is isc_dsql_sqlda_err and the number of this error is 335544583L

The weird thing is that the report, at which the error occurs, doesn't
report any data of the database.
We use InterBase 5.5 for NT and Delphi 4.

Is someone familiar with the meaning and the cause of this error.

Thanks
Marc van de Laar
marc.va...@spaarselect.nl

[Gerrit Stegehuis]

Marc van de Laar schreef:

>
> Sometimes when a user of our main application tries to print a report, the
> following database error occurs:
> SQLDA missing or incorrect version, or incorrect number/types of variables.
> The errorcode of this error, according to the Interbase language reference,
> is isc_dsql_sqlda_err and the number of this error is 335544583L
>

> Is someone familiar with the meaning and the cause of this error.
>

It is a nasty bug in Interbase that exists already for a long time (it
was there in 4.2, it is still there in 5.6), and only occurs on a remote
connection. You get this error sometimes the second time a stored
procedure is executed. I know of two work-arounds:

1. In Delphi, make sure to Unprepare the procedure after each call. Not
efficient, but seems to work.
2. Make sure the procedure has a SUSPEND statement where it should
return the parameters, and call it with a 'select ... from
proc(:param1,...)', not with 'execute procedure'.

I hope one of these 'solutions' solve your problem too.

Gerrit Stegehuis

[Claudio Valderrama C.]

Use IB 5.6, not 5.5, the upgrade is free, any reason to not be able to use
the newest version?
Second, if you select from your procedure by means of
select * from sproc
through TQuery.Open or the equivalent in the package you're using, you will
have no problems as far as I've seen. However, if you use use such procedure
by means of EXECUTE PROCEDURE or TQuery.ExecSQL or something alike, you'll
find problems when calling several times ExecSQL. You should Unprepare after
the next call => bug in IB.

C.
--
---------
Claudio Valderrama C.
Ingeniero en Informática - Consultor independiente
http://members.xoom.com/cvalde

Marc van de Laar wrote in message <8b5mug$9p...@bornews.borland.com>...
>Hello

>
>Sometimes when a user of our main application tries to print a report, the
>following database error occurs:
>SQLDA missing or incorrect version, or incorrect number/types of variables.
>The errorcode of this error, according to the Interbase language reference,
>is isc_dsql_sqlda_err and the number of this error is 335544583L
>

>The weird thing is that the report, at which the error occurs, doesn't
>report any data of the database.
>We use InterBase 5.5 for NT and Delphi 4.
>

>Is someone familiar with the meaning and the cause of this error.
>