Re: MySQL Datasource does not close connections

[xavier clavien]

hi

I could go forward in troubleshooting my problem and I think the problem is coming from MySQL and the MySQL connectors. I explain myself:

When troubleshooting I could notice that on a page that make the application crash, there are 4 DataSource control using MySQL Database and provider ".NET Framework Data Provider for MySQL" and when the page load I can see that 4 connections are opened for the user which seems normal at this point.

But the thing is when leaving the page, the connections are not close so after a few minutes using the application, all this user's connections are used on the MySQL server and then the application is crashing.

The application is almost finished and ready to publish so a solution would be good if it is not to re-code all the MySQL connections...