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 .)

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!