Subject Connection forcibily closed by the remote host
Author colincoleman2002

I have a very strange problem with a moderatly sized application
that recently has started playing up, we have not changed the
application but have changed the domain contraoller for the network
and thus had to demote and promote all the servers connected to
it...The usual SBS2k3 story. Anyway the problem symptoms first.

The Delphi 7 / IBO app on one page that creates an invoice crashes
the following error:
ISC ERROR CODE :335544721

Unable to complete network request to host "SPEC01".
Error reading data from the connection.
An existing connection was forcibily closed by the remote host.

TIB_Statement: "<TApplication>.For.

This happens when the table is posted then Commited, im am testing
to see if its the post or the commit that crashes, The database far
end is in another factory 20 miles down the road and has been using
this system for 4 years now via a VPN Connection, without a hitch.
the same program also
drives the local database(same structure) where the Alias points
simply to the local
network DB server, This local connection never crashes and leads me
to be belive that the application is not at fault. Also if i post
any invoices to the site B database whilst actually at site B it
never crashes either.

Even More information i found today, one of the other client
machines CAN run the invoicing system fine on site "B", but they are
using the old interbase drivers and not the Firebird client drivers that are running on both servers at sites
A and B and all clinet machines (I thought till today anyway!!!).

The application has about 180 forms some very very db intensive
forms but this particular form seems very simple in contrast.

I dont know where to start looking? is Interbase more forgiving than
Firebird 1.5? if so how/why ?

Any help would be appreciated.

we are using IBO 4.5Ai components.


Colin Coleman