Re: Slow access on XP using ADO with ODBC to SQL Server 2000 - any ideas?

All XP patches had been installed. What I'm at a loss to explain is why
one
copy of the app works, yet the other doesn't. I have also tested the copy
that has problems on this machine with another that is near identical -
same
hardware, same patches - and it doesn't have a problem. I guess I'll just
have to stick with Named Pipes for now and try to nail down the issue some
other time when Named Pipes no longer works properly ... not the ideal
situation, but this machine is in use 24/7 and I don't have another spare
to
use while attempting to find the source of the problem. I was hoping
someone
else might have seen something similar and be able to give me a starting
point. If I find the cause I'll post the solution.

I sympathise. I have been in this situation. There has to be a difference.
Is it worthwhile to run some TCPIP configuration diagnostics?
I would be looking for static diagnostics - something to run on both
machines and try and isolate any factor that is different.

Stephen Howe


.