Use vs2005 + sqlserver2008 to develop C/SProgramAfter the program is launched for a period of time, the following errors may occasionally occur in some functions:
A transmission error occurs when sending a request to the server. (Provider: TCP provider, error: 0-the remote host forces an existing connection to be closed .) ---> System. Data. sqlclient. sqlexception: A transmission error occurs when a request is sent to the server. (Provider: TCP provider, error: 0-the remote host forces an existing connection to be closed .)
At first, I thought it was a network connection problem and finally found it was a database connection string problem.
The previous database connection string is:
"Server = server; database = database; uid = uid; Pwd = PWD ";
Later changed:
"Server = server; database = database; uid = uid; Pwd = PWD; pooling = false ";
With the setting of pooling = false, the solution is OK!