Re: timeout expired on View

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I solve the problem with clients with MS Access by increasing the ODBC
timeout from 60 (by default) to 300. This can be done by opening the MS
Access SQL-Pass-Through query in Design mode and right clicking on the window
then accessing the properties. One of the properties is ODBC timeout.

But it still not resolve the problem with MS SQL Server Management Studio. I
have only MS SQL Management studio on client PC and when I executing a view I
have the same problem! Where I can change that query timeout on that client
PC in Management Studio?

"Erland Sommarskog" wrote:

Denny (Denny@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
Thanks for reply >>Erland Sommarskog
But I have already set - Connection time-out: 600 seconds and Execution
timeout:600 seconds.
Also in Tools-->Options-->Query Execution: Execution time-out:0
In Designers menu - Transaction time-out: 600 seconds
But it also not work I have the same problem - (“Error Source: .Net
SqlClient Data Provider. Error Message: Timeout expired. The timeout
period elapsed prior to completion of the operation or the server is not
responding. ”)

I see now that in your original post that you mentioned an application.
In a .Net app, you set the query timeout on either the Connection object
or the Command object with the CommandTimeout property.

And how to solve problem with MS Access (ODBC-call failed [Microsoft][ODBC
SQL Server Driver]Timeout expired (#0))

If you are using ADO, the answer is the same for ADO .Net. If you are
using something else, I don't know the answer, and it's more of an
Access question.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx


.

Relevant Pages

  • Re: Is there ever a reason to have a transaction around a select..
    ... cache-size rows are found during the SELECT operation, the client ... on the rowset state as the SELECT query walks the query plan fetch rowset. ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Problem using Access or Query Designer to run queries in SQL S
    ... The need for the group of financial analysts I support, is some ad-hoc query ... Therefore stored procedures called via pass-thru queries ... for their Access/Excel queries to fetch data from SQL server is still a huge ... I can instruct them to set the ODBC timeout ...
    (microsoft.public.sqlserver.odbc)
  • Re: Timeout expired troubleshooting suggestions
    ... Escalation, Lock Timeout, and Deadlock Chain events. ... Periodically the client recieves timeout expired messages and all subsequent inserts fail, as though connectivity has been totally broken. ... We stop and restart the client services (not sql server) and connectivity is restored, but all the inserts that failed remain in a que. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server 2000 query time out option, what does it do?
    ... The drop down menu ran a select query for 13 hours. ... > SQL sees the query as a valid running query and the timeout is ignored. ... When a client runs a query on SQL Server, and gets back a result set, to ...
    (comp.databases.ms-sqlserver)
  • Re: SQL Timeout Errors - Can Anyone Help?
    ... The timeout period elapsed prior to completion of the ... SQL Server does not time out. ... and you get further blocking and timeout. ... There are two possible reasons why a query takes more than 30 seconds ...
    (comp.databases.ms-sqlserver)