Does GetObject work with ASP?

[Rich]

Hello,

I have not been working with ASP for too long at this time
and am not real familiar with a lot of things about ASP.
I have searched for articles on the following question but
not come up with any definite answers. I would like to
know if it is possible to use GetObject in order to
read/write data between an ASP and an activeX
application. VBS supports GetObject, so I thought ASP
might, but I have not had any luck. Interestingly I can
use CreateObject with ASP but not GetObject. I
experimented with a homemade ActiveX exe I slapped
together with no luck - Can't create ActiveX object
error. I even tried it with an Excel workbook. Also did
not work. Before I assume you can't use GetObject with
ASP I thought I would check if maybe it is a special
syntax I need or GetObject isn't designed for ASP (Note: I
am adding my apps to the ROT to get the GetObject
functionality - which works fine from vbs). Any comments
appreciated.

Thanks,
Rich

[Aaron Bertrand - MVP]

> Again, not being argumentative, but can you give me an example of a

situation where letting a variable fall out of scope would have a different effect than setting it to Nothing?

Why should I set my objects to nothing?

Well, for one, when you explicitly set it to nothing, it is released
immediately (IIS 5.0 and later). If you don't bother, it will wait until
the page goes out of scope. I'll leave it as an exercise to the reader to
determine which option is more efficient.

I believe one example of much more detrimental behavior: A recordset object
that holds a pessimistic lock can tie up resources long after the page goes
out of scope, if the transaction is neither committed nor rolled back. Not
sure how trivial it is to reproduce and demonstrate this phenomenen.

Why people *want* to be lazy and leave out destruction statements is beyond
me. I've never trusted automatic garbage collection, and probably never
will -- I follow Bob's simple rule to the letter. Just write the extra 20
characters and be done with it.