Lucas,

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
roll...

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
work.

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
yet.

Thanks,

Brian

> -----Original Message-----
> From: Lucas Franzen [mailto:luc@...]
> Sent: Wednesday, 31 October 2001 9:28 PM
> To: IBObjects@yahoogroups.com
> 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.
>
>
> HTH
>
> Luc.
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Get your FREE VeriSign guide to security solutions for your
> web site: encrypting transactions, securing intranets, and more!
> http://us.click.yahoo.com/UnN2wB/m5_CAA/yigFAA/PhFolB/TM
> --------------------------------------------------------------
> -------~->
>
> ______________________________________________________________
> _____________
> IB Objects - direct, complete, custom connectivity to
> Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ______________________________________________________________
> _____________
> http://www.ibobjects.com - your IBO community resource for
> Tech Info papers,
> keyword-searchable FAQ, community code contributions and more
> !
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>