Re: ADO and SQL Server 6.5 Executing heavy proc
It's probably PRINT statements in there, or ROWCOUNTS popping into the
results. Comment out all PRINT statements, and SET NOCOUNT ON at the top of
D. Patrick Hoerter
anand verma wrote in message <email@example.com>...
>problem : executing heavy procs having multiple select , update and delete
>statesment with ado execute method or by command
>method i get message recordset close runtime error. eithe it have a final
>select statement for generating reports.
>I got help for setting querytimeout value so i set it to 0
>and i do execute those procs which have only select statements
>of assignment and 'if conditions' and one final select statment
>then it executes properly
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL