Re: SQL Timeout Error


Robert,

First of all, I am using Express versions of SQL Server 2005 and SQL Server
Management Studio. Currently, SQL Server 2005 Express is installed on my
hard drive. I am just playing around with it while I am waiting for my IT
department to create a regular version of SQL Server 2005 for me. Therefore,
I don't think I have a .net client application. If I do, where do I go to
debug it? Plus, I don't think I have the things (SqlDataSource, etc.) that
you are asking for. If I do, where can I find them?

I don't know it will relate to what you are looking for. When I finish with
this project, I will have SQL Server as my back-end database and Access as my
front-end database.

Below is the code for my View that I am getting the error:

USE [Database]
GO
/****** Object: View [dbo].[View] Script Date: 06/23/2009 13:12:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER VIEW [dbo].[View]
AS
SELECT tblField
FROM dbo.Table
GROUP BY tblField

Thank you for your helps and your patience.

"Robert Lakinski" wrote:


Thanks for your response. How can I check whether SqlConnection object is
estiablished

By debugging your .net client application. Can you post some code?
Which version of Visual Studio are you using ?
What kind of data access objects are you using: SqlDataSource,
SqlDataAdapter or SqlCommand, linq ...?

Robert Lakinski


, and how do I set the CommandTimeout property? I am sorry I am
still new to SQL Server.

Thanks.

"Robert Lakinski" wrote:

Hi, AccessHelp

If you are using .net client app to select data from the view, check the
following:

1. Whether SqlConnection object establishes connection to the sql server
successfully - check ConnectionString, ConnectionTimeout property
(default
= 15 sec)
2. If the connection was established, you may need to set the
CommandTimeout
property of the SqlCommand object to a value > 30 sec (default = 30 sec)

Robert Lakinski

"Accesshelp" <Accesshelp@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8C19B329-0148-4EDE-A1EC-A2E3A3674C47@xxxxxxxxxxxxxxxx
Good morning all,

I just created a View, and when I tried to run it, I received the
following
error message:

error message: timeout expired. the timeout elapsed prior to
completion
of
the operation or the server is not responding.

error source: .Net SqlClient Data Provider

When I researched the above error message via Google, the solution is
to
run
the CommandTimeout, and I don't know how to run it.

First of, if the CommandTimeout is the solution to the error, can you
tell
me how to run it?

If the CommandTimeout is not the solution, can you help me with the
error?

Thanks.




.

Relevant Pages

  • Re: "Timeout expired" for simple ADO.NET SQL Server query
    ... It sounds like the problem may be on your SQL Server. ... Kevin Spencer ... >> This can be alleviated by increasing the CommandTimeout. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Two connections with Delphi 7 Professional?
    ... The timeout value is also a property of TADOConnection (CommandTimeout). ... > more than one connection at a time,without any restrictions? ... Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. ...
    (borland.public.delphi.database.ado)
  • Re: Large Number Of Inserts
    ... > SQL server 2000. ... CommandTimeout properties of the Connection object or the CommandTimeout ...
    (microsoft.public.data.ado)
  • Re: does CommandTimeout takes effect?
    ... > I convert my application from BDE to ADO, In BDE version, ... > SQL server. ... > this, But I write a test program to test this, found CommandTimeout ...
    (borland.public.delphi.database.ado)
  • RE: ODBC SQL Server Driver: Timeout expired error
    ... Not sure why but it could be your connection timeout. ... there is a CommandTimeout on the connection object too so try ... SQL Server Developer Support Engineer ... Microsoft OLE DB Provider for ODBC Drivers error '80040e31' ...
    (microsoft.public.data.oledb)
Quantcast