Professional Web Applications Themes

SQL Timeout Expired - Microsoft SQL / MS SQL Server

> However, I have the IIS timeout set to 30 minutes This is for a script, and will only go 30 minutes if no other portion of the code times out first.   Why is the connection timeout relevant? Is it the connection, or a command that is timing out? Perhaps you meant to fiddle with the value for conn.commandTimeout -- http://www.aspfaq.com/2343...

  1. #1

    Default Re: SQL Timeout Expired

    > However, I have the IIS timeout set to 30 minutes

    This is for a script, and will only go 30 minutes if no other portion of the
    code times out first.
     

    Why is the connection timeout relevant? Is it the connection, or a command
    that is timing out? Perhaps you meant to fiddle with the value for
    conn.commandTimeout -- http://www.aspfaq.com/2343



    Aaron Guest

  2. #2

    Default Re: SQL Timeout Expired

    I was just changing any timeout value I could find, in
    hopes of correcting the problem. I also set the command
    timeout to 0 as well.
     
    >
    >This is for a script, and will only go 30 minutes if no[/ref]
    other portion of the 
    >
    >Why is the connection timeout relevant? Is it the[/ref]
    connection, or a command 
    value for 
    Scott Guest

  3. #3

    Default Re: SQL Timeout Expired

    Hi Scott,

    On which object(Connection / Command) are you running your Sql Query?

    However setting Connection.CommandTimeOut=0 and Command.CommandTimeout=0 ,
    should solve your problem.

    Praveen Maddali
    MCSD, MCDBA

    "Scott" <DexterAxle.Com> wrote in message
    news:025d01c34bdb$a85241f0$gbl... 
    > >
    > >This is for a script, and will only go 30 minutes if no[/ref]
    > other portion of the 
    > >
    > >Why is the connection timeout relevant? Is it the[/ref]
    > connection, or a command 
    > value for [/ref]


    praveen Guest

Similar Threads

  1. ASP + SQL Server - Timeout Expired
    By David Morgan in forum ASP
    Replies: 2
    Last Post: October 1st, 09:21 PM
  2. Replies: 0
    Last Post: August 7th, 12:52 PM
  3. Timeout expired in connection
    By Jones Ambrosi in forum ASP Database
    Replies: 5
    Last Post: August 6th, 05:21 PM
  4. Timeout expired
    By Phil Grimpo in forum ASP Components
    Replies: 3
    Last Post: July 31st, 07:33 PM
  5. ado.net Timeout expired
    By Shahab Gerami in forum ASP.NET General
    Replies: 0
    Last Post: July 3rd, 02:35 PM

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