Joshua Brown
|
| Posted: 11/22/2002, 11:41 AM |
|
I get this error if I'm running a SQL Query that takes longer than 30
seconds. I need to extend the time out... How?
Source: Grid invAdvantageTra
Error: Timeout expired (Microsoft OLE DB Provider for SQL Server)
SELECT [CRRecordID], [CRAgentID], [uaptdate], [uapttime], [ufname],
[ulname], [usfirst], [uslast], [uleadtype], [umarstat], [uphone],
[ulocation], [ustreet], [uemail] FROM [TdiXL].[dbo].[stvTDITodaySets]
|
|
|
 |
Frank Rocco
|
| Posted: 11/22/2002, 12:46 PM |
|
For IIS, under the WebSite Tab, there is a Connection Timeout setting.
HTH
Frank Rocco
"Joshua Brown" <josh@atclubs.com> wrote in message
news:arm18l$2a7$1@news.codecharge.com...
> I get this error if I'm running a SQL Query that takes longer than 30
> seconds. I need to extend the time out... How?
>
> Source: Grid invAdvantageTra
> Error: Timeout expired (Microsoft OLE DB Provider for SQL Server)
> SELECT [CRRecordID], [CRAgentID], [uaptdate], [uapttime], [ufname],
> [ulname], [usfirst], [uslast], [uleadtype], [umarstat], [uphone],
> [ulocation], [ustreet], [uemail] FROM [TdiXL].[dbo].[stvTDITodaySets]
>
>
>
|
|
|
|
Joshua Brown
|
| Posted: 11/22/2002, 1:47 PM |
|
I set it to 600, it made no difference, any other suggestions?
"Frank Rocco" <farocco@hotmail.com> wrote in message
news:arm52r$9iq$1@news.codecharge.com...
> For IIS, under the WebSite Tab, there is a Connection Timeout setting.
>
> HTH
>
> Frank Rocco
>
> "Joshua Brown" <josh@atclubs.com> wrote in message
>news:arm18l$2a7$1@news.codecharge.com...
> > I get this error if I'm running a SQL Query that takes longer than 30
> > seconds. I need to extend the time out... How?
> >
> > Source: Grid invAdvantageTra
> > Error: Timeout expired (Microsoft OLE DB Provider for SQL Server)
> > SELECT [CRRecordID], [CRAgentID], [uaptdate], [uapttime], [ufname],
> > [ulname], [usfirst], [uslast], [uleadtype], [umarstat], [uphone],
> > [ulocation], [ustreet], [uemail] FROM [TdiXL].[dbo].[stvTDITodaySets]
> >
> >
> >
>
>
|
|
|
|
David Harrison
|
| Posted: 11/23/2002, 7:21 PM |
|
What SQL Server are you using?
"Joshua Brown" <josh@atclubs.com> wrote in message
news:arm8mf$ft4$1@news.codecharge.com...
> I set it to 600, it made no difference, any other suggestions?
>
> "Frank Rocco" <farocco@hotmail.com> wrote in message
>news:arm52r$9iq$1@news.codecharge.com...
> > For IIS, under the WebSite Tab, there is a Connection Timeout setting.
> >
> > HTH
> >
> > Frank Rocco
> >
> > "Joshua Brown" <josh@atclubs.com> wrote in message
> >news:arm18l$2a7$1@news.codecharge.com...
> > > I get this error if I'm running a SQL Query that takes longer than 30
> > > seconds. I need to extend the time out... How?
> > >
> > > Source: Grid invAdvantageTra
> > > Error: Timeout expired (Microsoft OLE DB Provider for SQL Server)
> > > SELECT [CRRecordID], [CRAgentID], [uaptdate], [uapttime], [ufname],
> > > [ulname], [usfirst], [uslast], [uleadtype], [umarstat], [uphone],
> > > [ulocation], [ustreet], [uemail] FROM [TdiXL].[dbo].[stvTDITodaySets]
> > >
> > >
> > >
> >
> >
>
>
|
|
|
|
James Moss
|
| Posted: 11/23/2002, 8:48 PM |
|
Have you optimized the query?
"Joshua Brown" <josh@atclubs.com> wrote in message
news:arm8mf$ft4$1@news.codecharge.com...
> I set it to 600, it made no difference, any other suggestions?
>
> "Frank Rocco" <farocco@hotmail.com> wrote in message
>news:arm52r$9iq$1@news.codecharge.com...
> > For IIS, under the WebSite Tab, there is a Connection Timeout setting.
> >
> > HTH
> >
> > Frank Rocco
> >
> > "Joshua Brown" <josh@atclubs.com> wrote in message
> >news:arm18l$2a7$1@news.codecharge.com...
> > > I get this error if I'm running a SQL Query that takes longer than 30
> > > seconds. I need to extend the time out... How?
> > >
> > > Source: Grid invAdvantageTra
> > > Error: Timeout expired (Microsoft OLE DB Provider for SQL Server)
> > > SELECT [CRRecordID], [CRAgentID], [uaptdate], [uapttime], [ufname],
> > > [ulname], [usfirst], [uslast], [uleadtype], [umarstat], [uphone],
> > > [ulocation], [ustreet], [uemail] FROM [TdiXL].[dbo].[stvTDITodaySets]
> > >
> > >
> > >
> >
> >
>
>
|
|
|
|
Joshua Brown
|
| Posted: 11/25/2002, 5:23 AM |
|
I'm running SQL Server 2000 and yes, I have optimized the query as much as
possible, I know there is a setting somewhere where I can change the Query
Timeout, well atleast I'm sure it can be done in ASP? Any other Ideas?
"James Moss" <jmoss111@bellsouth.net> wrote in message
news:arplnh$f7f$1@news.codecharge.com...
> Have you optimized the query?
> "Joshua Brown" <josh@atclubs.com> wrote in message
>news:arm8mf$ft4$1@news.codecharge.com...
> > I set it to 600, it made no difference, any other suggestions?
> >
> > "Frank Rocco" <farocco@hotmail.com> wrote in message
> >news:arm52r$9iq$1@news.codecharge.com...
> > > For IIS, under the WebSite Tab, there is a Connection Timeout setting.
> > >
> > > HTH
> > >
> > > Frank Rocco
> > >
> > > "Joshua Brown" <josh@atclubs.com> wrote in message
> > >news:arm18l$2a7$1@news.codecharge.com...
> > > > I get this error if I'm running a SQL Query that takes longer than
30
> > > > seconds. I need to extend the time out... How?
> > > >
> > > > Source: Grid invAdvantageTra
> > > > Error: Timeout expired (Microsoft OLE DB Provider for SQL Server)
> > > > SELECT [CRRecordID], [CRAgentID], [uaptdate], [uapttime], [ufname],
> > > > [ulname], [usfirst], [uslast], [uleadtype], [umarstat], [uphone],
> > > > [ulocation], [ustreet], [uemail] FROM
[TdiXL].[dbo].[stvTDITodaySets]
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
|
|
|
David Harrison
|
| Posted: 11/25/2002, 7:35 AM |
|
Under the Connection that you use set the Connection Timeout. But what I
think is getting you is the SQL Servers setting of Query Timeout that is set
at the Server level. I suspect that it has been set to 30 seconds from it's
default value of 600. This is changed by going under Enterprise Manager and
right clicking on the Server and going to the Connections Tab and changing
the Query Timeout field to 600 or 0 if you want no timeout.
Hope this helps.
David Harrison
"Joshua Brown" <josh@atclubs.com> wrote in message
news:art87p$t91$1@news.codecharge.com...
> I'm running SQL Server 2000 and yes, I have optimized the query as much as
> possible, I know there is a setting somewhere where I can change the
Query
> Timeout, well atleast I'm sure it can be done in ASP? Any other Ideas?
> "James Moss" <jmoss111@bellsouth.net> wrote in message
>news:arplnh$f7f$1@news.codecharge.com...
> > Have you optimized the query?
> > "Joshua Brown" <josh@atclubs.com> wrote in message
> >news:arm8mf$ft4$1@news.codecharge.com...
> > > I set it to 600, it made no difference, any other suggestions?
> > >
> > > "Frank Rocco" <farocco@hotmail.com> wrote in message
> > >news:arm52r$9iq$1@news.codecharge.com...
> > > > For IIS, under the WebSite Tab, there is a Connection Timeout
setting.
> > > >
> > > > HTH
> > > >
> > > > Frank Rocco
> > > >
> > > > "Joshua Brown" <josh@atclubs.com> wrote in message
> > > >news:arm18l$2a7$1@news.codecharge.com...
> > > > > I get this error if I'm running a SQL Query that takes longer than
> 30
> > > > > seconds. I need to extend the time out... How?
> > > > >
> > > > > Source: Grid invAdvantageTra
> > > > > Error: Timeout expired (Microsoft OLE DB Provider for SQL Server)
> > > > > SELECT [CRRecordID], [CRAgentID], [uaptdate], [uapttime],
[ufname],
> > > > > [ulname], [usfirst], [uslast], [uleadtype], [umarstat], [uphone],
> > > > > [ulocation], [ustreet], [uemail] FROM
> [TdiXL].[dbo].[stvTDITodaySets]
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
|
|
|
Joshua Brown
|
| Posted: 11/26/2002, 12:27 PM |
|
I checked, the timeout is set at 0 for no timeout. I've lost hope.
"David Harrison" <davidh@saltydog.net> wrote in message
news:artfvr$d5o$1@news.codecharge.com...
> Under the Connection that you use set the Connection Timeout. But what I
> think is getting you is the SQL Servers setting of Query Timeout that is
set
> at the Server level. I suspect that it has been set to 30 seconds from
it's
> default value of 600. This is changed by going under Enterprise Manager
and
> right clicking on the Server and going to the Connections Tab and changing
> the Query Timeout field to 600 or 0 if you want no timeout.
>
> Hope this helps.
> David Harrison
>
> "Joshua Brown" <josh@atclubs.com> wrote in message
>news:art87p$t91$1@news.codecharge.com...
> > I'm running SQL Server 2000 and yes, I have optimized the query as much
as
> > possible, I know there is a setting somewhere where I can change the
> Query
> > Timeout, well atleast I'm sure it can be done in ASP? Any other Ideas?
> > "James Moss" <jmoss111@bellsouth.net> wrote in message
> >news:arplnh$f7f$1@news.codecharge.com...
> > > Have you optimized the query?
> > > "Joshua Brown" <josh@atclubs.com> wrote in message
> > >news:arm8mf$ft4$1@news.codecharge.com...
> > > > I set it to 600, it made no difference, any other suggestions?
> > > >
> > > > "Frank Rocco" <farocco@hotmail.com> wrote in message
> > > >news:arm52r$9iq$1@news.codecharge.com...
> > > > > For IIS, under the WebSite Tab, there is a Connection Timeout
> setting.
> > > > >
> > > > > HTH
> > > > >
> > > > > Frank Rocco
> > > > >
> > > > > "Joshua Brown" <josh@atclubs.com> wrote in message
> > > > >news:arm18l$2a7$1@news.codecharge.com...
> > > > > > I get this error if I'm running a SQL Query that takes longer
than
> > 30
> > > > > > seconds. I need to extend the time out... How?
> > > > > >
> > > > > > Source: Grid invAdvantageTra
> > > > > > Error: Timeout expired (Microsoft OLE DB Provider for SQL
Server)
> > > > > > SELECT [CRRecordID], [CRAgentID], [uaptdate], [uapttime],
> [ufname],
> > > > > > [ulname], [usfirst], [uslast], [uleadtype], [umarstat],
[uphone],
> > > > > > [ulocation], [ustreet], [uemail] FROM
> > [TdiXL].[dbo].[stvTDITodaySets]
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
|
|
|
Sixto Luis Santos
|
| Posted: 11/26/2002, 1:59 PM |
|
Are you sure it is your query that is timing out?
Do you get the same error with a smaller resultset?. Try limiting the number
of rows with TOP 10 and see if that executes.
Try running the query in Query Analyzer.
Is your source table a view? Maybe a nested view (a view within a view)? If
that is the case, checking the estimated execution plan in Query Analyzer
could show potential bottlenecks. Maybe a view with time-consuming
sub-queries? Most sub-queries can be re-written as faster executing joins.
Are you behind a firewall? Is port 1433 blocked?
The CCS server connection, is the SQL Server's IP correctly set?
Try creating a server alias. Click start/run, and type cliconfg.exe for the
client configuration utility.
Hope you solve your problem soon.
Regards,
Sixto
"Joshua Brown" <josh@atclubs.com> wrote in message
news:arm18l$2a7$1@news.codecharge.com...
> I get this error if I'm running a SQL Query that takes longer than 30
> seconds. I need to extend the time out... How?
>
> Source: Grid invAdvantageTra
> Error: Timeout expired (Microsoft OLE DB Provider for SQL Server)
> SELECT [CRRecordID], [CRAgentID], [uaptdate], [uapttime], [ufname],
> [ulname], [usfirst], [uslast], [uleadtype], [umarstat], [uphone],
> [ulocation], [ustreet], [uemail] FROM [TdiXL].[dbo].[stvTDITodaySets]
>
>
>
|
|
|
|
|
