On 25 Feb 2004 at 22:39, ericboyajian wrote:

>however, there seems to be a difference between FB 1.0 and 1.5 that
>is causing giving me a problem.

Yes, FB 1.5 is more strict for SQL syntax.

>EXEC SQL
> PREPARE TRANSACTION gds_trans Q1 INTO sqlda FROM :string;

Show us Q1.

>With FB 1.0, this worked fine with the final SQLCODE == 0.
>
>With FB 1.5, the final SQLCODE == -901. The error code is 335544332,
>which means:
> Invalid transaction handle (expecting explicit transaction start)

Make sure that you have firebird.msg from FB1.5 everywhere because
it has been changed since FB1

SY, Dimitry Sibiryakov.