Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Location
    New York
    Posts
    15

    Unanswered: remotely running a stored procedure

    I have an ASP page calling a stored procedure. When I run the stored procedure on the server (under root) it took 40 - 50 minutes. However, when the ASP page calls it, it dies after about a minute. Any ideas on how to allow the SP to run to completion?

  2. #2
    Join Date
    Mar 2004
    Posts
    370
    Check the configs on ODBC, OLE DB provider for any timeout setting. BTW, your sp that took 40,50 min to run is somewhat suspicious for me! would you please sending its source here?
    -Good luck.

  3. #3
    Join Date
    May 2006
    Location
    New York
    Posts
    15
    I see I can set the commandTimeout property, so I'll try that.
    BTW, it builds a DB (a few tables) from one large table (14K+ records)
    Last edited by blmgyossi; 10-04-06 at 13:47.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •