ODBC Connection Pooling and Temp Tables

Hi, i need to filla .NET Data Set with 3 related tables, the bottom
line is for the best explain i need frst to do a select XXX into
temp...

And the fill the tables with joins to the TEMP table.

Im using ADO.NET Odbc Data Provider and IBM INFORMIX ODBC DRIVER (3.00
TC3)

I would like to work with/without Connection pooling support all
scenarios, but how connection pooling affects temp tables ?

Its possible that the first query goes thru a connection and laters
with others not finding the temp table ??

Also: The query is issued by a WCF service so probably multiple
threads can access the methods that run the querys.

How i can work with temp tables supporting connection pooling ?

Thanks people!!! (sorry my english)

Enrique


.

Relevant Pages
Loading