ESP Context Identifier

  • I need a way to identify a "connection" in an Extended Stored Procedure. Something along the lines of the SPId in Query Analyzer. I need to maintain "connection" specific resources across calls to my ESP. If the user disconnects or closes the connection I need a way to identify those resources for cleanup.

    I've tried using srv_pfield(...); none of its responses seem usable. The response to SRV_SPID is actuall the KPID which has a nasty habit of changing periodically

    Is there some other way I could do this, maybe use the SRV_PROC pointer to retrieve something?



    PeteK
    I have CDO. It's like OCD but all the letters are in alphabetical order... as they should be.

  • Doh!

    It would appear that I can use the value of the SRV_PROC pointer as it represents the connection

    Thanks, you guys are great! And nobody flamed me for being an idiot



    PeteK
    I have CDO. It's like OCD but all the letters are in alphabetical order... as they should be.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply