tableadapters, Stored Procedure and temp tables

[Phil Barber]

I have a stored procedure that contains several temp tables, I am attempting
to assign a tableadapter to the Sp. when it goes to create the persistent
fields (in the wizard) I get Select command error Invalid object #DrY, which
happens to be the name of the first declared temp table in the SP.
how do properly connect a Sp to a tableAdapter that uses Temp tables
Thanks
(using: VS 2005, C#, ASP.net)
Phil Barber

 

[tarheeltek]

You might want to try temp tables declared with ## I believe they live
for the life of the creating connection not just the scope of the
procedure call.

Jeff Langston
Cashless Systems

 

[Mark Baldwin]

How does this affect connection pooling? Do the temp tables exist even when
another client reuses the connection?

 

[Marc Gravell]

In most pooling scenarios, the system sends a "reset connection"
message (I can't recall the specific command - it probably varies by
vendor) when a connection is "closed" and "opened" (quoted as the
actual connection remains unaltered). As such, connection-specific
entities (like #tables) will evaporate. Longer lived entities (like
##tables or regular tables) will remain.

Marc

 

[Anthony Jones]

I changed temp table to '##Temp_....' , but still I am getting the ame

problem error, If you know any other solution. please let me know
The same as what problem? If you start a new thread then you can't assume
that potential respondants have can put such statements into context.