Please help urgently:<BR><BR>I am writing an ASP page that creates one connection and uses 20 recordsets. However, whenever I create the recordset using &#039set rsNEW = server.createobject("ADODB.Recordset")&#039 and then open the recordset it creates a new connection to the SQL server. This is not ideal as I want to optimally use one connection in total and NOT 20 simultaneous connections. Any help on this would be HIGHLY appreciated!