'Connection terminated' errors in C/S application...

Client workstations getting 'conection terminated' message through the clien
t
app.
Happens sporadically and we can't seem to make it happen. Sometimes the
users get error messages from SQL Srvr and sometimes just the 'con term'
message. I've checked the switch, the wire, the patch level, the clients
(2000, xp pro, 98se), drivers, apps, nics, power, phases of the moon...
Have an open case w/microsoft for over a month! No help... Updated mdac,
jet, SQL, keep alives, max ports, wait time... Using named pipes and tcp.
Have done limited net monitoring (through MS worthless net monitor prog,
doing ethereal next) and can't come up with any definitive 'ah hah' and alas
a fix.
Anyone with an opinion, possible fix? This has gotten VERY old. Some days,
up to a week, no errs. Other days up to 5 or 6 an hour! YIKES!
Clients are 98se, 2k, XP Pro.
Server 2003 SBS SP1 throughout
SQL Server 2000 SP3aHi
I assume there is no information in the Windows Event log or SQL Server log
to help you?
Have you tried running the client on the server (with and without shared
memory)?
You may want to try setting up a separate (small) test environment to see if
it still happens with other hardware on a standalone network.
John
"drkc" wrote:

> Client workstations getting 'conection terminated' message through the cli
ent
> app.
> Happens sporadically and we can't seem to make it happen. Sometimes the
> users get error messages from SQL Srvr and sometimes just the 'con term'
> message. I've checked the switch, the wire, the patch level, the clients
> (2000, xp pro, 98se), drivers, apps, nics, power, phases of the moon...
> Have an open case w/microsoft for over a month! No help... Updated mdac,
> jet, SQL, keep alives, max ports, wait time... Using named pipes and tcp.
> Have done limited net monitoring (through MS worthless net monitor prog,
> doing ethereal next) and can't come up with any definitive 'ah hah' and al
as
> a fix.
> Anyone with an opinion, possible fix? This has gotten VERY old. Some days,
> up to a week, no errs. Other days up to 5 or 6 an hour! YIKES!
> Clients are 98se, 2k, XP Pro.
> Server 2003 SBS SP1 throughout
> SQL Server 2000 SP3a
>