<div>
<div class="content wysiwyg-content">
Hello experts,<br />
<br />
I am trying to use Coldfusion to connect to a remote database using an ADODB.Connection (ODBC) . &nbsp;I know it is good practice to close these connections as soon as you are done, but what if i left it open? &nbsp;What would be the negative effects? &nbsp;The reason I ask is because obviously I am getting a slow response time trying to connect to a remote database, and am looking for ways to speed it up.<br />
<br />
Thanks!
</div>
</div>


Hello experts,

I am trying to use Coldfusion to connect to a remote database using an ADODB.Connection (ODBC) .  I know it is good practice to close these connections as soon as you are done, but what if i left it open?  What would be the negative effects?  The reason I ask is because obviously I am getting a slow response time trying to connect to a remote database, and am looking for ways to speed it up.

Thanks!

leaving ODBC connection open

Web development can range from developing the simplest static single page of plain text to the most complex web-based internet applications, electronic businesses, and social network services using a wide variety of languages and standards, including the familiar HTML, JavaScript and jQuery, ASP and ASP.NET, PHP, ColdFusion, CSS, PHP, Flex and Flash, but also the implementation of a broad list of standards including XML, WSDL, SSDL, VoiceXML and many more.