Hi all. SQL query aborts when SQL statement is too long or complex. Firebird seems to fail to handle the error of complecated SQL statement when an error occurs at fbembedde.dll. SQL query that includes IN operator with multiple columns and OR conditons have been aborted in our development environment. What is the cause of forced termination?
error: <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"> <System> <Provider Name="Application Error" /> <EventID Qualifiers="0">1000</EventID> <Level>2</Level> <Task>100</Task> <Keywords>0x80000000000000</Keywords> <TimeCreated SystemTime="2013-11-21T00:33:03.000000000Z" /> <EventRecordID>3463</EventRecordID> <Channel>Application</Channel> <Computer>WIN-SAH55JS7A8C</Computer> <Security /> </System> <EventData> <Data>w3wp.exe</Data> <Data>7.5.7601.17514</Data> <Data>4ce7afa2</Data> <Data>fbembed.DLL</Data> <Data>2.5.1.26351</Data> <Data>4e89609d</Data> <Data>c00000fd</Data> <Data>000000000015090a</Data> </EventData> </Event> The embedded DB is accessed via .NetFramework Web service in IIS. Environment information: OS:win2008R2Server IIS:7.5 fbembed.dll:2.5.1.26351 FirebirdSql.Data.FirebirdClient.dll:2.6.0 .NetFramework:3.5SP1