Timeout Expired

Expand Post »

I have a Stored Procedure that is called through VB6 for a report. The Reports were working great until yesterday. Now all of the reports that use that sp are timing out. The default time is set to 60. I have adjusted this to 1000 and the report finally displays. When I login to sql using Management Studio I can run this sp and it takes less then a second. All data is being transferred correctly. I am at a loss. Nothing in the Code has been changed.
Any ideas will be greatly appreciated.

thanks

Similar Threads

Timeout Expired in VB.NET
Timeout expired in ASP
Time Expired, pool is full in ASP.NET
How to resolve timeout expired in Crystal Report. in Visual Basic 4 / 5 / 6
Timeout expired... Error detected by Database DLL in Visual Basic 4 / 5 / 6

ProfessorPC

Reputation Points: 31

Solved Threads: 29

Posting Whiz in Training

Offline

270 posts
since Dec 2007

Permalink

Jan 20th, 2009

Re: Timeout Expired

Found my problem. I was passing 4 params. I found an article on Parameter Sniffers in 2005 SQL. Once I added another set or params with an existing value it all worked great.

sql Syntax (Toggle Plain Text)
@param1 INT,
@param2 INT,
@param3 INT,
@param4 INT,
@paramsniff1 INT = 0,
@paramsniff2 INT = 0,
@paramsniff3 INT = 0,
@paramsniff4 INT = 0
 
SET paramsniff1 = @param1 
--etc..
@param1 int,
@param2 int,
@param3 int,
@param4 int,
@paramsniff1 int = 0,
@paramsniff2 int = 0,
@paramsniff3 int = 0,
@paramsniff4 int = 0

set paramsniff1 = @param1 
--etc..

Last edited by ProfessorPC; Jan 20th, 2009 at 10:38 pm.

ProfessorPC

Reputation Points: 31

Solved Threads: 29

Posting Whiz in Training

Offline

270 posts
since Dec 2007

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Please Help Me

Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: POS Printer programming with OPOSPOSPrinter.ocx

DaniWeb Message

Cancel Changes

User Name
Password