Subject RE: [IBO] SQLDA missing or incorrect version
Author Brian Dunstan

this is getting very scary :-(

I think you are right on the money. In the first place I had this problem I
have a TIB_StoredProc and the SP uses ForNext and Suspend. I set the
StoredProcForSelect and sure enough the problem went away.

The next place I had this problem the component was a TIB_DSQL. The SP it
called takes a bunch of parameters but returns nothing. I changed the
TIB_DSQL to a TIB_StoredProc and called Prepare before executing it the
first time and that problem went away also. At this point I think I am on a

The same error then popped up in a TIB_DSQL that does a select on a view
that returns a single row.
I have been off and studied the news groups but not really got any leads, so
I have used this:
if Prepared then Unprepare;
if not prepared then Prepare;
Sure enough the problem has gone, but I think this is really dirty and am
worried about what will fail next.

Later in the same program I found what would be next :-(
I have another TIB_DSQL that does a COUNT(). After the THIRD execution it
now causes an Access Violation!

Remember, all this code has been tested with a local connection and did

I suppose my problem is now that I am apparently chasing a IB bug through my
code and I have no way of predicting where it will crop up next.

Thanks for you help. I feel like I am close to the problem, but no solution



> -----Original Message-----
> From: Lucas Franzen [mailto:luc@...]
> Sent: Wednesday, 31 October 2001 9:28 PM
> To:
> Subject: Re: [IBO] SQLDA missing or incorrect version
> Brian Dunstan schrieb:
> >
> > Hi,
> >
> > I am getting this error:
> >
> > "SQLDA missing or incorrect version, or incorrect
> number/type of variables"
> Olgd known StoredProc bug.
> In short:
> when you don't want to change too much you can unprepare / prepare
> before executing or have alook at the StoredProcForSelect-property and
> the problem will be gone.
> In long:
> Search this newsgroup and the Interbase archives, there are plenty of
> explanations.
> Luc.
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Get your FREE VeriSign guide to security solutions for your
> web site: encrypting transactions, securing intranets, and more!
> --------------------------------------------------------------
> -------~->
> ______________________________________________________________
> _____________
> IB Objects - direct, complete, custom connectivity to
> Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ______________________________________________________________
> _____________
> - your IBO community resource for
> Tech Info papers,
> keyword-searchable FAQ, community code contributions and more
> !
> Your use of Yahoo! Groups is subject to