I have a situation with one of our clients where one of our utility applications is losing it's SQL connection after it has successfully retrieved data.
For instance, the customer can log into the application, load a list of members, but on trying to view an individual members details we'll get the following exception
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
The Connection String uses an IP address to get to the server - don't know if this makes behaviour any different - I would doubt it though.
Have tried it with pooling=false but no difference.
Have elongated the server time out setting to no avail.
We have multiple clients connection to the DB server in this fashion but only some of them are experiencing this behaviour.
At this point, at a loss as to where to look next - hopefully someone has some fresh ideas about what might be happening - or can ask some questions that might open up those ideas
Life without beer is no life at all
All beer is good, some beers are just better than others