Timeout expired in sql server problem

Posted by Avinash on Stack Overflow See other posts from Stack Overflow or by Avinash
Published on 2010-03-31T06:55:50Z Indexed on 2010/03/31 7:03 UTC
Read the original article Hit count: 419

Filed under:

asp

|

sqlserver2005

set con2=server.CreateObject("ADODB.Connection")
con2.ConnectionTimeout =1200
con2.open "Driver={SQL Server};server=111.111.111.11;user id=xx;pwd=xxx;Database=xxx"
con2.execute("DELETE FROM tablename WHERE fieldid NOT IN(SELECT fieldid FROM tablename2)")
con2.close
set con2=nothing

when i running this query using asp the following error occured. How to solve this issue?

Microsoft OLE DB Provider for ODBC Drivers error '80040e31'

[Microsoft][ODBC SQL Server Driver]Timeout expired

© Stack Overflow or respective owner

Related posts about asp

How to associate jquery validation when only one button if there are many??

as seen on Stack Overflow - Search for 'Stack Overflow'
Greetings, In my current project, I have gridview, search button, text box for search, text box, and submit button. -I should input string in the search box then click search button. -when click search button, it will retrieve all matches records then bind them to the view grid. -then when I click… >>> More
How to associate jquery validation with only one button if there are many?

as seen on Stack Overflow - Search for 'Stack Overflow'
Greetings, In my current project, I have gridview, search button, text box for search, text box, and submit button. -I should input string in the search box then click search button. -when click search button, it will retrieve all matches records then bind them to the view grid. -then when I click… >>> More
What's New in ASP.NET 4

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
The .NET Framework version 4 includes enhancements for ASP.NET 4 in targeted areas. Visual Studio 2010 and Microsoft Visual Web Developer Express also include enhancements and new features for improved Web development. This document provides an overview of many of the new features that are included… >>> More
April 14th Links: ASP.NET, ASP.NET MVC, ASP.NET Web API and Visual Studio

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Here is the latest in my link-listing blog series: ASP.NET Easily overlooked features in VS 11 Express for Web: Good post by Scott Hanselman that highlights a bunch of easily overlooked improvements that are coming to VS 11 (and specifically the free express editions) for web development: unit… >>> More
Create Resume problem

as seen on Stack Overflow - Search for 'Stack Overflow'
hello mates, i am working on a project of online resume management system and i am encountering an exception while creating resume. [b] Exception: Data type mismatch in criteria expression. [/b] here is my code for Create Resume-1.aspx.cs using System; using System.Data; using System.Configuration; using… >>> More

Related posts about sqlserver2005

SqlServer2005 Enterprise Fast Recovery, SqlAgent Availability, and Replication

as seen on Server Fault - Search for 'Server Fault'
I have a database under SqlServer2005 Enterprise 64bit sp3, that is in phase 3 of 3 of recovery after a reboot without normal shutdown. It looks like with fast Recovery, the database became available when recovery moved into phase 3. However, it seems (based on message in SqlAgent log), that SqlAgent… >>> More
"select * from table" vs "select colA,colB,etc from table" interesting behaviour in SqlServer2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Apology for a lengthy post but I needed to post some code to illustrate the problem. Inspired by the question What is the reason not to use select * ? posted a few minutes ago, I decided to point out some observations of the select * behaviour that I noticed some time ago. So let's the code speak… >>> More
deleting records from multiple tables at a time with a single query in sqlserver2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I wanna delete records from child tables as well as parent table with in a single query. please find the query given below. here response header is the primary table and responseid is the primary key. DELETE FROM responseheader FROM responseheader INNER JOIN responsepromotion ON responseheader… >>> More
My log file is so big, after truncate it 2 days, it still big like before

as seen on Server Fault - Search for 'Server Fault'
I'm using sql server 2005 and the log is too big 23 gbs (if you compare with the data file only 8GB). I've already run the truncate, after that the log file is 24mb but after 2 days, it becomes 23gbs. My database is full backup mode. I have the maintain plan is 2 hours will have diff backup and 24hours… >>> More
Facing problem in configuring Reporting Server

as seen on Server Fault - Search for 'Server Fault'
Dear All, I am unable to configure reporting server with sql server 2005 express edition. I have posted the link of a screen shot which shows the status.when ever i go to configure the reporting services it gives me the following errors(see screen shot)...also unable to start the reporting services… >>> More