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

    Unanswered: want to send a database command and keep working

    I want to send a database command from ASP and continue doing other things without waiting for the DB to finish. Is that possible using classic ASP

  2. #2
    Join Date
    Aug 2005
    Location
    D/FW, Texas, USA
    Posts
    78
    I've never seen it acomplished. IF it is possible, I believe you would need to write some sort of VB6 COM component to do the work. Then you could potentially call a method of your COM component to start the process and return. Very possible in .NET, but I don't think so in Classic.

    Are you trying to get something that runs between page calls? Or are you just looking for something to start and be finished by the time your page is done generating?

    If it's the former, you may be able to insert a record into a table, and have a process on the server looking for new records. Then it would run in the back ground, and all the page would have to wait for is the single record insertion. (Similar to a Message Queue.)
    --wayne
    SELECT * FROM Users WHERE Clue>0
    0 rows returned

Posting Permissions

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