Re: Issue with retrieving large data over web using Stored Procedu

Actually the stored procedure works fine because it retrieve data while I
execute the sp at the SQL Server 2005.
I don't think I need to check at the SQL Profiler because I am testing at
the SQL 2005 level.
How do I use "on error resume next"?

Thanks in advance.

"Bob Barrows [MVP]" wrote:

Justin Doh wrote:
Hello.
I moved my stored procedure and tables from SQL 2000 to SQL 2005.
I am having an issue to retrieve a large amount of data using previous
stored procedure (sp) over web (ASP page).
Other sp works fine, but one sp that retrieves large amount of data
does not even get executed over ASP page.

Have you verified this with SQL Profiler? If not, you should.


First,
I tried to increase the server timeout by doing this way.
<% server.ScriptTimeout = 40000 %>

Second,
I also included ConnectionTimeout and CommandTimeout to see if it
would help any such as..

With rsReport
.ConnectionString = ConnOLAP
.ConnectionTimeout = 4800

This one is irrelevant to this issue

.CommandTimeout = 4800

4800 is ridiculous, especially if the procedure is not getting executed.

.Load(strSQL)
End With

When I executed sp at SQL Server 2005 level, I got the data fine
(after long period of process), but when it gets executed over web
(ASP), no data gets retrieved.

Is there any suggestions to fix this problem?


If you have "on error resume next" anywhere, comment it out so you will see
errors.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"



.

Relevant Pages

  • Scheduled DTS package doesnt run
    ... I created a DTS package wich runs a standard Stored Procedure in the master ... I call the stored procedure by an Execute SQL Task object with all necesarry ... When I log on as administrator on the server and run the package manually it ... Error string: SQL Web Assistant: Could not execute the SQL statement. ...
    (microsoft.public.sqlserver.dts)
  • Re: Issue with retrieving large data over web using Stored Procedu
    ... It appears that it was hitting the stored procedure, ... Is there any tool in the SQL Profiler that analyze each Trace? ... The maximum amount of time for a script to execute was exceeded. ... do it at ASP. ...
    (microsoft.public.inetserver.asp.db)
  • Re: user permissions
    ... I'm not sure how that would work with the security as the kill sql command is ... I would like to add some comments regarding 'EXECUTE AS' clause in SQL ... this issue by creating a stored procedure with 'EXECUTE AS' clause in SQL ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.security)
  • Re: Create Storedprocedure with VB6? Is this possible?
    ... you can create and execute an SQL query that includes the ... can SQL Server Management Studio." ... Can VB6 create a stored procedure on the fly. ... Call the connection's Execute method, ...
    (microsoft.public.vb.database.ado)
  • Re: ASP and stored procedure problem (syntax error ?)
    ... I am typing execute sp_sel_companynames @sql, I think this is why it is ... falling over. ... >> page to the stored procedure to return a recordset that i can write ...
    (microsoft.public.inetserver.asp.db)