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@gmail.com]

Re: tableadapters, Stored Procedure and temp tables

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]

Re: tableadapters, Stored Procedure and temp tables

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

--
Best regards
Mark

[Marc Gravell]

Re: tableadapters, Stored Procedure and temp tables

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

[Rajeev Biligere]

tableadapters, Stored Procedure and temp tables

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

Thanks for the help !
Rajeev



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

[Anthony Jones]

Re: tableadapters, Stored Procedure and temp tables

<Rajeev Biligerewrote in message news:2008724102 037rbiligere@cb iz.com...

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.



--
Anthony Jones - MVP ASP/ASP.NET