Obtaining Recordset From Middle-Tier COM Component


Can I pass ADO objects like Command and Recordset to an ActiveX DLL (acting as a middle layer) so that it automatically fills the data in them and I can access it from ASP?


You do not need to pass the Command and Recordset objects to an ActiveX DLL acting as your middle layer. You can simply invoke a method in your ActiveX DLL that returns a Recordset object. For example, suppose you create a Method called GetRecordSet in your VB COM component. The signature for the method (function declaration) would look like this:

Public Function GetRecordSet(byval strConnectionString as string, _    byval strSQL as string) as ADODB.Recordset

Within this function, you would declare a Connection object, use the “strConnectionString” variable to connect to the database and populate a Recordset object using the SQL statement passed in the argument “strSQL”. You can then return this Recordset object as the return value of your function where objRS is the recordset variable you created in the previous function code:

  Set GetRecordset = objRS

From within your ASP page, you would then call this method as follows:

Dim objRS, strSQL, strConnstringDim objDALstrConnString = "Your valid connection string here"strSQL = "Select * from customers"Set objDAL = Server.CreateObject("MyComponent.MyClass")set objRS = objDAL.GetRecordSet(strConnString, strSQL)set objDAL = Nothing

Now you have a recordset “objRS” obtained from the middle tier.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin


The Latest

your company's audio

4 Areas of Your Company Where Your Audio Really Matters

Your company probably relies on audio more than you realize. Whether you’re creating a spoken text message to a colleague or giving a speech, you want your audio to shine. Otherwise, you could cause avoidable friction points and potentially hurt your brand reputation. For example, let’s say you create a

chrome os developer mode

How to Turn on Chrome OS Developer Mode

Google’s Chrome OS is a popular operating system that is widely used on Chromebooks and other devices. While it is designed to be simple and user-friendly, there are times when users may want to access additional features and functionality. One way to do this is by turning on Chrome OS

homes in the real estate industry

Exploring the Latest Tech Trends Impacting the Real Estate Industry

The real estate industry is changing thanks to the newest technological advancements. These new developments — from blockchain and AI to virtual reality and 3D printing — are poised to change how we buy and sell homes. Real estate brokers, buyers, sellers, wholesale real estate professionals, fix and flippers, and beyond may