access

[Clod Patry]

when im going to my jsp: index.jsp?action=sessions
im getting error such as:

An Error Occurred
--------------------------------------------------------------------------------
 
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too many client tasks.  

what is that error exactly ?
and how can i fix it ?
thanks in advance

[Bear Bibeault]

It probably means that you have too many connections to the DB open. Are you sure that you are closing them?
In any case, this would be better off in the JDBC forum. Moving it there.
bear

[Clod Patry]

what should i put at the end? just to be sure ?

[Jeanne Boyarsky]

Clod,
Every time you are done with a query, you should call conn.close() for the connection object. Similarly, it is good to close the result set and statement objects.