Exception control on abnormal disconnected connections in ADO .Net connection pool
Qiang Lu · Jisuanji gongcheng yu sheji · 2005
Dynamic website often gets the essential data from database to create web page, so it will consume heavy cost to establish database connection between web application and database. ADO .net uses connection pool to reduce this cost of establishing database connection. However, the abnormal disconnected connections often appear in ADO .net connection pool, the pool manager will allot these actually invalid connections to the request applications. When applications use these connections to execute SQL statement, con- nection exceptions are generated. A solution is shown to avoid these connection exceptions being generated in the SQL server .net data provider.