During a command time-out, the command is cancelled when a response is not received within the time-out. After the cancel is sent to the server, the driver may possibly lose the connection's state. To fill in this gap, the Adaptive Server ADO.NET Data Provider support for connection pooling is enhanced.
The Adaptive Server ADO.NET Data Provider now closes the real connection whenever a command time-out occurs and marks the client's connection as closed. If the application wants to continue using the connection, it reopens the connection, goes to the pool, and if necessary establishes a new connection to the server.
