Kill ObjectContext

[KK]

Hi,

I am using COM+ components for executing SQL stored procs. These
VB.dlls are called by ASP pages.

I can see the status of each object in the status view COM+

I am generating Excel reports by using pre-defined templates, with the
help of COM+ for executing stored procs.

But I am surprised to see the status of a component running with more
call_time even though I stopped the execution of a report in the middle
of execution by clicking stop in the IE browser, closed the IE browser.
The object has not been released in COM+ application. It continued to
execute the timeconsuming SQL query and the call_time value is
increasing...

How to kill the object instance as soon as the client (IE) stopped or
closed?

Please assist.

Regards.

 

[Mark Schupp]

The server does not know that the browser has closed unless it checks. Your
com components will need to check Response.IsClientConnected periodically.

 

[MnMs]

well...

for crying out loud.

You've got a wrapper in a wrapper in a wrapper...

go figggggger.

who knows.

drink some beer.

 

[KK]

Hi,

checking Response.IsClientConnected periodically? How to do that in
COM? because it is throwing error Run-time error '424: "Object
required"

Do we need to include any reference in the project?

Pls assist.

Thanks.

 

[Mark Schupp]

You can get the response object in VB like this if you reference the Com+
services library

Set objContext = GetObjectContext()
Set Response = objContext("Response")

Or just pass it in from the ASP page that calls the com object method.

 

[KK]

Thanks Mark. Its working in COM+