Timeout Expired

Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
Thread Solved

•
•
Join Date: Dec 2007
Posts: 252
Reputation: ProfessorPC is an unknown quantity at this point 
Solved Threads: 27
ProfessorPC ProfessorPC is offline Offline
Posting Whiz in Training

Timeout Expired

 
0
  #1
Jan 20th, 2009
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
Reply With Quote Quick reply to this message  
•
•
Join Date: Dec 2007
Posts: 252
Reputation: ProfessorPC is an unknown quantity at this point 
Solved Threads: 27
ProfessorPC ProfessorPC is offline Offline
Posting Whiz in Training

Re: Timeout Expired

 
1
  #2
Jan 20th, 2009
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) 
  1. @param1 INT,
  2. @param2 INT,
  3. @param3 INT,
  4. @param4 INT,
  5. @paramsniff1 INT = 0,
  6. @paramsniff2 INT = 0,
  7. @paramsniff3 INT = 0,
  8. @paramsniff4 INT = 0
  9.  
  10. SET paramsniff1 = @param1 
  11. --etc..
Last edited by ProfessorPC; Jan 20th, 2009 at 10:38 pm.
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread has been marked solved.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the Visual Basic 4 / 5 / 6 Forum


Views: 750 | Replies: 1
Thread Tools Search this Thread



Tag cloud for Visual Basic 4 / 5 / 6
* 6 429 2007 access activex add age append application basic beginner birth bmp c++ calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh report retrieve save search sendbyte sites sort sql sql2008 sqlserver struct subroutine table tags textbox time timer urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC