G
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?
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?