Professional Web Applications Themes

Command.Timeout option - ASP

All, I am using ADO to connect to a database to get some data that I then display on my web page. I build the entire script in ASP code the finally use response.write to get the web page itself When I create the connection object set objConn = Server.Create.Object("Server.Command) objConn.Timeout = 90 Even thought I set the time out to 90 seconds the time out occurs in 30 seconds. And this is pain as I have some large queries returning some 100K records. Is there any other way of increasing the timeout Is it a Registry setting on IIS? ...

  1. #1

    Default Command.Timeout option

    All,
    I am using ADO to connect to a database to get some data that I then display
    on my web page.
    I build the entire script in ASP code the finally use response.write to get
    the web page itself
    When I create the connection object
    set objConn = Server.Create.Object("Server.Command)
    objConn.Timeout = 90

    Even thought I set the time out to 90 seconds the time out occurs in 30
    seconds. And this is pain as I have some large queries returning some 100K
    records.
    Is there any other way of increasing the timeout
    Is it a Registry setting on IIS?

    Thanks
    Jawahar


    Jawahar Rajan Guest

  2. #2

    Default Re: Command.Timeout option

    Perhaps you should post the majority of your relevant code. The code you
    posted below has a number of syntax errors. Also post what error you're
    receiving, and on what line (not the number, but point out the line).

    Ray at home

    "Jawahar Rajan" <jrajannc.rr.com> wrote in message
    news:RrJRa.244930$_w.9606098twister.southeast.rr. com...
    > All,
    > set objConn = Server.Create.Object("Server.Command)
    > objConn.Timeout = 90

    Ray at Guest

Similar Threads

  1. Replies: 3
    Last Post: April 29th, 02:21 AM
  2. Modifier Keys (Command Option Shift) failing in FH10 OSX 10.1
    By art101 webforumsuser@macromedia.com in forum Macromedia Freehand
    Replies: 2
    Last Post: October 23rd, 04:41 PM
  3. Replies: 0
    Last Post: August 7th, 12:52 PM
  4. Echo command option for db2
    By Blair Adamache in forum IBM DB2
    Replies: 1
    Last Post: August 1st, 07:14 PM
  5. Replies: 1
    Last Post: July 11th, 02:50 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139