Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 ADO and Temporary tables

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-29 : 09:14:52
Eugene writes "I made a stored procedure that uses a temporary table. I want to send the results to my ASP page. My ADO recordset can't seem to get those results so I get errors everytime. Now I read somewhere that ADO is really not capable of reading temporary tables and that article suggests the use of regular tables. Is this true and is the suggestion a practical one? What do you suggest as a workaround if indeed ADO can't read temporary tables?

I use SQL Server 2000 in Windows 2000 Advanced Server SP 2.

Thanks a lot guys."
   

- Advertisement -