Archives of the TeradataForum

Message Posted: Mon, 31 Jan 2005 @ 09:49:08 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: Teradata ODBC and ASP - Session remains open

From:		Anomy Anom

<-- Anonymously Posted: Monday, January 31, 2005 02:29 -->

Joseph Massena wrote:

"Does anyone knows if there is a existing problem with teradata sessions staying open when using odbc in asp pages? We have encountered that the teradata session stays open even if the asp page is closed or is forced to close with vbscript commands Connection.Close."

This behaviour sounds to as connection pooling. ODBC will under certain circumstances maintain connections to a datasource even when a Connection.Close is issued.

This rather complex feature of ODBC is described in the following link:

msdn.microsoft.com/library/en-us/dnmdac/html/pooling2.asp?frame=true

Hope this can clear things out for you.