I have the same problem. We recently moved our ASP app from Windows 2000 to
Windows 2003 Web servers, and when we did this our problems started popping
up. When we moved to the new servers, we also changed the connect strings
from using ODBC DSN's to OLEDB connect strings. To troubleshoot if that was
the cause, we copied the modified app back to the 2000 box, complete with
the new connect strings, and never saw the error happen there. We've tried
adding adding "Network Library=dbmssocn" into our connect strings, but that
didn't help. We added the SQL server to the hosts & lmhosts.sam files, and
did the same on the SQL server (added the web servers to the files) - but
that didn't help. We used the client network utility to enable both TCP/IP
& Named Pipes on the web servers - but that didn't help.
I've seen too many other posts on google to believe that this is an isolated
problem. I've also seen posts that made me believe that this has something
to do with going from Win2000 to Win2003.
The error is very sporadic. We have 100+ users on the app all day long, and
only every once in a while the error happens. If the user hits refresh
right after the error, the connection work just fine.
Please help!
Scott Ivey