<div>
From a database standpoint, multiple people accessing your site will show multiple concurrent processes on your database.
</div>


From a database standpoint, multiple people accessing your site will show multiple concurrent processes on your database.

<div>
<div class="content wysiwyg-content">
Experts,<br />
In a simple ASP script, where you open one connection, then open two recordsets in a row<br />
<br />
cnn.ConnectionString = &quot;xxx&quot;<br />
cnn.CursorLocation = 3 <br />
cnn.Open<br />
Set RS1 = cnn.Execute(&quot;select a from b&quot;)<br />
Set RS2 = cnn.Execute(&quot;select c from d&quot;)<br />
..... do some stuff with the results<br />
RS1.close<br />
RS2.close<br />
cnn.close<br />
<br />
After doing that, before closing RS1 or RS2, the active connection of each recordset is the same cnn first opened? Or ADO will automatically open a second connection, identical to cnn, for RS2?<br />
<br />
I am seeing multple connections on my database and I suspect that it is happening. If you have many active recordsets, and they are all open, do I have many database connections ou just one? Disconnected recordset would help reduce open connections on the database?<br />
<br />
Thanks in advance, Joao<br />
<br />

</div>
</div>


Experts,
In a simple ASP script, where you open one connection, then open two recordsets in a row

cnn.ConnectionString = "xxx"
cnn.CursorLocation = 3 
cnn.Open
Set RS1 = cnn.Execute("select a from b")
Set RS2 = cnn.Execute("select c from d")
..... do some stuff with the results
RS1.close
RS2.close
cnn.close

After doing that, before closing RS1 or RS2, the active connection of each recordset is the same cnn first opened? Or ADO will automatically open a second connection, identical to cnn, for RS2?

I am seeing multple connections on my database and I suspect that it is happening. If you have many active recordsets, and they are all open, do I have many database connections ou just one? Disconnected recordset would help reduce open connections on the database?

Thanks in advance, Joao



Recordset and connections

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

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.

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.