<div>
sorry to say but the most reliable way to do this is to go through your code and make sure you close each connection manually:<br />
<br />
conn.open connectionString<br />
<br />
'-- do stuff<br />
<br />
if conn.State &lt;&gt;&nbsp;0 then conn.Close<br />
set conn = nothing
</div>


sorry to say but the most reliable way to do this is to go through your code and make sure you close each connection manually:

conn.open connectionString

'-- do stuff

if conn.State <> 0 then conn.Close
set conn = nothing

<div>
if you've already checked this, you want to disable the autoconnect flag in MySQL, as this may be the problem as well.
</div>


if you've already checked this, you want to disable the autoconnect flag in MySQL, as this may be the problem as well.

<div>
<div class="content wysiwyg-content">
From time to time I find some sleepy connection in my mysql database. Im looking for a way to kill these through an asp page. I am looking for a code sample in asp.
</div>
</div>


From time to time I find some sleepy connection in my mysql database. Im looking for a way to kill these through an asp page. I am looking for a code sample in asp.

Kill Mysql Sleepy Connections with ASP

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.