> Our software is querying Firebird database with 70KB sql (file size)
> which generates error when run against firebird db (2.1) when I modify
> the sql and remove some of bits making it 64KB in size it runs fine. Is
> this the limit? can i change the server options to run SQL which is
> bigger than 64KB.

No.

The max. size of one SQL statement is ~ 64KB.



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com