Storedprocedure not responding


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Storedprocedure not responding

  1. #1
    Join Date
    Dec 2008
    Posts
    1

    Storedprocedure not responding

    Storedprocedure not responding:
    When we run storedprocedure from sqlserver 2000 using query analyzer with same parameter the procedure run successfully with in 30 seconds but with same parameter if we call this sp from classic asp storedprocedure does not respond and command timeout occurs. We tried to set command timeout to 50,000 seconds but no luck.
    Following is the code:
    Code:
            Dim objCommand 
            Dim rs  
            Dim conn 
    
            Set conn = New ADODB.Connection
            conn.ConnectionString = "....."
            conn.Open
    
            Set objCommand = New ADODB.Command
            objCommand.CommandText = "{call sp_Ch_Stats(?,?,?,?,?,?,?)}"
            objCommand.ActiveConnection = conn
    
            objCommand(0) = "12/29/2008 11:59:59 PM"
            objCommand(1) = "1/1/2004"
            objCommand(2) = 0
            objCommand(3) = 0
            objCommand(4) = 6
            objCommand(5) = "desc"
            objCommand(6) = "12/30/2008 11:56:44 AM"
    
            objCommand.CommandTimeout = 50000
    
            objCommand.Execute
    Last edited by Hack; 12-31-2008 at 09:28 AM. Reason: Added Code Tags

  2. #2
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    Quote Originally Posted by shabbir.hussain View Post
    if we call this sp from classic asp
    Moved From ASP.NET
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

  3. #3
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    Have a look at this.
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

Similar Threads

  1. Replies: 1
    Last Post: 01-28-2008, 11:59 AM
  2. Access stops responding when making project
    By Peter Mount in forum Database
    Replies: 0
    Last Post: 11-09-2001, 12:37 AM
  3. OAS 4.0.8.2 stop responding!
    By Marcus Nyholm in forum Web
    Replies: 0
    Last Post: 08-21-2000, 05:48 AM
  4. Replies: 2
    Last Post: 05-23-2000, 03:11 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center