TechNote (Archived)

ColdFusion MX 7: ODBC socket error--Too many client tasks

Issue

A ColdFusion application may experience the following error when using the ODBC Socket to connect to Microsoft Access:

 Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too many client tasks.

Reason

The reason for this error is that the ODBC Socket uses a JDBC connection to ODBC. This type of connection is single threaded. If the data source definition in ColdFusion uses connection pooling, then multiple connections can be made to the database at one time, causing a concurrency problem. One way to work around the problem is to restart the ColdFusion MX ODBC Server. However, this typically causes the following error:

 Error Occurred While Processing Request Error Executing Database Query. [Macromedia][SequeLink JDBC Driver]Connection closed due to session kill.

Solution

The best way to work around this problem is to uncheck the "Maintain Connections" checkbox under the Advanced Settings for the data source defininition in the ColdFusion Administrator. This way, only one connection at a time can be made to the database.