devxlogo

Don’t use implicit connections when opening a Recordset

Don’t use implicit connections when opening a Recordset

As most ADO developers know well, there are basically two distinct syntax for opening a Connection and then a Recordset: you can explicitly create and open a Connection object, and then pass it to the 2nd argument of the Recordset’s Open method (or assign to the Recordset’s ActiveConnection property, which has the same effect). Or you can create an implicit connection object by passing a connection string to the 2nd argument of the Recordset’s Open method.

In regular Visual Basic programs, the two techniques are equivalent, but when you work under ASP the story is different, and it’s more complex. In fact, when you create a Recordset object using Server.CreateObject and then open it – thus creating an implicit Connection object – that connection isn’t automatically returned to the Connection pool when the Recordset is closed (or when the page completes its execution). Instead, the connection is returned to the pool only when it times out, usually after one minute. Needless to say, this can be an obstacle that can prevent your site from scaling correctly, and should be avoided by creating a Connection object explicitly.

Notice that you don’t have this problem if you instantiate the Recordset using the CreateObject function, instead of the Server.CreateObject method.

See also  5 Tips to Manage a Remote Workforce
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist