Re: Temporary table not clearing rows across connections

Is it connection pooling enbaled within your ADO provider? If this is the case then pay attention to the fact that when you close a connection in your code that connection is not actually closed at the database level but, instead, it is returned in the connection pool for further reuse therefore the temporary table will not be clean up.

alec. Received on Tue May 02 2006 - 01:33:33 CDT