Passing Objects to COM Components from VBScript
Written by Eric Smith, Northstar Computer Systems LLC
Using COM components; that is, ActiveX DLLs created in a language like Visual Basic, can really speed up processing on your ASP application. If you ever need to pass an object to a public method (property, subroutine, or function), use a data type of Variant within the COM component. Here's an example of a method that accepts an ADO Connection object and then stores it in a local object variable for later use:
Option Explicit
Private m_dcnDB As ADODB.Connection
…
Public Sub DoSomething(dcnDB As Variant)
Set m_dcnDB = dcnDB
…
End Sub
The reason you have to do this is that VBScript has no object data type -- everything's a variant. If you don't do this, you may get Type Mismatch errors for the object you're trying to pass in. Note that any object parameter is subject to this problem -- not just ADO objects.
Keywords: [
Uncategorized ASP Tips
]
Publication Date: 7/1/1999
|