aspose file tools*
The moose likes JDBC and the fly likes [Microsoft][ODBC Microsoft Access Driver] Too many client tasks. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "[Microsoft][ODBC Microsoft Access Driver] Too many client tasks." Watch "[Microsoft][ODBC Microsoft Access Driver] Too many client tasks." New topic
Author

[Microsoft][ODBC Microsoft Access Driver] Too many client tasks.

kahkean chor
Ranch Hand

Joined: Jan 26, 2013
Posts: 56
anyone face this problem before? i open close the page about 4-5 times and it will start hang and at last prompt out this exception message [Microsoft][ODBC Microsoft Access Driver] Too many client tasks.
can someone give me the solution? thanks in advanced
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

I expect you aren't closing the connection after you finish the "page" (whatever that might be). So eventually there are too many open connections and the database refuses to accept any more. So make sure you close the connection when you're finished with it. (Or alternatively, don't keep creating new connections but use an existing connection if there is one available.)
kahkean chor
Ranch Hand

Joined: Jan 26, 2013
Posts: 56
Paul Clapham wrote:I expect you aren't closing the connection after you finish the "page" (whatever that might be). So eventually there are too many open connections and the database refuses to accept any more. So make sure you close the connection when you're finished with it. (Or alternatively, don't keep creating new connections but use an existing connection if there is one available.)



the connections still exist even i dispose the page?
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

I don't know. I haven't seen any of your code so I have no idea how you're handling your connections. As for "disposing a page", whatever that means, why would it do anything with those connections?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: [Microsoft][ODBC Microsoft Access Driver] Too many client tasks.