ADO.NET SQL2000 Stored procedure - error configuring sqldataapdapt

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a stored procedure, that is pretty lengthy. It has 2 temp tables, one of which the final select statement is ran against to be returned as the result. When configuring the dataadapter, I get warning that the the temp table is an "Invalid Object MyTable". At first because of how datasets work (aware of table relationships by using PK, FK, and referential integrity), I thought the warning was because my temp table doesn't have a PK constraint, but adding a PK to the temp table made no difference
 
Additional Info:
warning given on SQLdataadapter config is:
Invalid object name '#temptable'

Error given when generating Dataset from the dataadapter:
Retrieving the schema for sqlDataAdpter123 failed.
Invalid object name '#temptable'
 
Back
Top