sqldataadapter using SQLserver 2000 stored procedure error

[Guest]

Using a lengthy stored procedure that has 2 temp tables, one of which is the table that the final SELECT is performed against to return the SP result response. The stored procedure works fine in query analyzer, odbc call, or thru other connection/client like Crystal Report Connection so I know the SP is not the problem directly.

When I configure my sqldataadaptor, I get a warning "Invalid Object #myTempTable", but then errors when generating the dataset. My initial thought was that since the dataset objects use PK, FK, and referential integrity, that it was a problem that the temp table in the stored procedure didn't have a PK, but adding one made no difference.

Any ideas, or seen info on this problem before?

 

[William \(Bill\) Vaughn]

Consider that temporary tables created within a SP are dropped when the SP
ends.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

Using a lengthy stored procedure that has 2 temp tables, one of which is

the table that the final SELECT is performed against to return the SP result
response. The stored procedure works fine in query analyzer, odbc call, or
thru other connection/client like Crystal Report Connection so I know the SP
is not the problem directly.

When I configure my sqldataadaptor, I get a warning "Invalid Object

#myTempTable", but then errors when generating the dataset. My initial
thought was that since the dataset objects use PK, FK, and referential
integrity, that it was a problem that the temp table in the stored procedure
didn't have a PK, but adding one made no difference.