I am inserting data in a table. The insert statements are formed and
fired to the database.

The number of statements fired are large..

After a particular time I get he error as follows





Unhandled Exception: FirebirdSql.Data.Common.IscException: Exception of
type FirebirdSql.Data.Common.IscException was thrown.

at FirebirdSql.Data.Gds.GdsStatement.Free(Int32 option)

at FirebirdSql.Data.Common.StatementBase.Release()

at FirebirdSql.Data.Gds.GdsStatement.Dispose(Boolean disposing)

at FirebirdSql.Data.Firebird.FbCommand.Release()

at FirebirdSql.Data.Firebird.FbCommand.Dispose(Boolean disposing)

at System.ComponentModel.Component.Finalize()



Unable to complete network request to host "10.22.6.15". Error writing
data to the connection. An existing connection was forcibly closed by
the remote host.



But if I write the insert statements to a file and run them I works
fine.

Is it that there are huge number of insert statement s with integrity
constraint violation. But if I would have been this the it should have
given this error when running the insert statements independently
(batch).



Regards,
Santosh M.
Associate Consultant - Investment Banking Group
PrimeSourcing(tm), The Global IT Services Business from i-flex - "Add
Value Reduce Risk"
http://www.iflexsolutions.com/services/services.asp
i-flex solutions limited - Mumbai
Office Direct: 91-22-5642-7136
Office Board: 91-22-5642-7000 x 7136
Mobile: 91-98196-89155
Email: santosh.mayekar@...

:-) A person who smiles in the face of adversity probably has a
scapegoat :-)





[Non-text portions of this message have been removed]