Need to Cancel a Query runnnign between ASP and Teradata

Third Party Software

Need to Cancel a Query runnnign between ASP and Teradata

We have a web application running ASP and COM (DLL) with Teradata as backend. User wants a Cancel button which should clear the query from the browser as well as kill or stop the query running on Teradata.

Is this something that's doable? If so, how?

Thanks in advance!

Sameer
2 REPLIES
Enthusiast

Re: Need to Cancel a Query runnnign between ASP and Teradata

In ASP Code, you can use 'IsClientConnected' property present in 'Response' object to verify whether client is Connected to Database to continue further processing with Teradata Database server.

Re: Need to Cancel a Query runnnign between ASP and Teradata

Thanks Renugopal! What you mentioned will help me check if client is connected to Web Server or not. However, what I need is ability to terminate a query on Teradata through my ASP code.