I'm pretty sure you should be using (forcing TCP/IP connection):
ips-name:D:\Dir_name\DBNAME.GDB

using \\server\drive:\path is a hybrid NetBeui / TCP/IP so I don't know what
it will actually end up using.

on the server, localhost is fine, certainly for FB1.x.

The server should clear any remote (i.e. it won't clear localhost),
connection a couple of minutes after the offending workstation is rebooted.

With the above connection string, does the error change to 10054?

I'm surprised performance declines on a 14mb db, how many users?

Jason Chapman
JAC2 Consultancy

Training - Development - Consultancy
Delphi, InterBase, Firebird, OOAD, Development lifecycle assistance,
Troubleshooting projects, QA.....
www: When I get round to it....
Mob: (+44) 07966 211 959 (preferred)
Tel: (+44) 01928 751088



""sllflanagan"" <sflanagan@...> wrote in message
news:aof62a+938e@......

> --- In ib-support@y..., "Jason Chapman (JAC2)" <jason@j...> wrote:
> > Does this corrupt the DB, why do you have to do a backup / restore?
> >
> > What is you connection string to the database? What components are
> you
> > using to get to the DB?
> >
>
> 1. It does not corrupt the DB but does cause hanging or phantom
> connections that cause the DB to grow and performance to decline.
> Since the DB is about 14MB that (usually) takes 2 min.
> 2. Connect string from RF PCs is
> \\ips-name\D:\Dir_name\DBNAME.GDB where ips-name is the DB server.
> Connect string on the server used by services is
> LOCALHOST:D:\Dir_name\DBNAME.GDB
> 3. Components (?) are using Delphi6 and the BDE ver 5.11.
> For more detail I can consult the vendor.
>
> Thank you for you help.
> -Steve Flanagan
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>