80040e31 Db Error Microsoft Ole Provider Server Sql
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Microsoft OLE DB Provider for SQL Server microsoft ole db provider for sql server error 80040e31 timeout expired error '80040e31' - Timeout expired SQL Server > SQL Server Data
Asp Microsoft Ole Db Provider For Sql Server Error 80040e31
Access Question 0 Sign in to vote Hi I have an ASP page that runs a stored procedure server scripttimeout to pull data back from the SQL 2005 server. The query runs fine in SQL Query Analyser and takes approx 45 seconds. At exactly 30 seconds i get the
Microsoft Ole Db Provider For Sql Server Error '80040e31' Query Timeout Expired
80040e31 - Timeout Expired. I have set the CommandTimeout value at 60000 "conn.commandtimeout=60000" Still the connection times-out after 30 seconds. The query does work as it has it works occasionally but not very often. The problem appears to be that something is ending the communication. Thanks Paul Friday, May 15, 2009 2:32 PM Reply | Quote Answers 0 query timeout expired sql server Sign in to vote Hi Paul, I believe the CommandTimeout is a property of the command, rather than the connection. Try this and see if it helps: command.CommandTimeout = 60000This post is provided 'as is' and confers no express or implied warranties or rights. Marked as answer by Dan BenediktsonModerator Friday, May 15, 2009 5:46 PM Friday, May 15, 2009 5:46 PM Reply | Quote Moderator All replies 0 Sign in to vote Hi Paul, I believe the CommandTimeout is a property of the command, rather than the connection. Try this and see if it helps: command.CommandTimeout = 60000This post is provided 'as is' and confers no express or implied warranties or rights. Marked as answer by Dan BenediktsonModerator Friday, May 15, 2009 5:46 PM Friday, May 15, 2009 5:46 PM Reply | Quote Moderator 0 Sign in to vote Hi Dan Can you expand what you mean a little? Here is my connection string, I tried to add in command.CommandTimeout = 60000 But the object "command" doesn't exist _________________________________________________________________________ MM_dataconn_ST
Audio/Visual Club Case and Cooling Fetish CPU & Motherboard Technologia Mobile Computing Outpost Networking Matrix Other Hardware Agora Classifieds Ars DIY Forum
Microsoft Ole Db Provider For Sql Server Query Timeout Expired
(Name TBD!) Operating Systems & Software Battlefront Microsoft OS & Software
Microsoft Odbc Sql Server Driver Query Timeout Expired
Colloquium Linux Kung Fu Windows Technical Mojo Distributed Computing Arcana Macintoshian Achaia Programmer's Symposium sql server timeout expired the timeout period elapsed The Server Room Ars Lykaion Gaming, Extra Strength Caplets The Lounge The Soap Box The Boardroom The Observatory Ars Help & Feedback Ars Subscription Member https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b00394d0-52c2-4a50-b3a8-d0acb6ab2ebd/microsoft-ole-db-provider-for-sql-server-error-80040e31-timeout-expired?forum=sqldataaccess Areas Image Galleries SQL Server Timeout expired (ASP/SQL Server question) 10 posts Veritas Ars Scholae Palatinae Tribus: Houston, TX Registered: May 31, 2000Posts: 603 Posted: Tue May 22, 2001 9:00 am OK, here are the details. I have an SQL server with a database that is currently in used on a live website. The website is currently running as a cold fusion app. I http://arstechnica.com/civis/viewtopic.php?t=981111 have spent the past week converting all the cold fusion to ASP. Now, I am ready to test my conversion. So, I made a copy of the live database for testing, changed the DSN on my webserver to point to the test database, setup the username and password for the test database correctly, and changed my Initial Catalog in my ASP code to point to the test database.This is what I get whenever I run queries against the test database:quote:Microsoft OLE DB Provider for SQL Server error '80040e31' Timeout expired /pjr/joblist_results.asp, line 72 This is line 72 of joblist_results.asp:code:Set dbRS = dbCommand.ExecuteObviously, it is hanging on the execution of the query. I know the query is correct because I set the all the database stuff (DSN, Initial Catalog, etc..) back to the live database and ran the query against that and everything worked fine.Any clues of what I might be doing wrong with the test database? Kurt Ars Tribunus Angusticlavius et Subscriptor Registered: Jun 1, 1999Posts: 8775 Posted: Tue May 22, 2001 9:26 am What's the query and what is the structure of the table(s) it's querying? Veritas Ars Scholae Palatinae Tribus:
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn http://stackoverflow.com/questions/2550995/timeout-expired-in-sql-server-problem more about Stack Overflow the company Business Learn more about hiring developers or https://bytes.com/topic/asp-classic/answers/56987-timeout-error-question posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Timeout expired in sql server problem up vote 1 sql server down vote favorite 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 sql-server-2005 asp-classic ado share|improve this question edited Dec 1 '11 at 2:36 Joel Coehoorn microsoft ole db 248k92440661 asked Mar 31 '10 at 6:55 Avinash 1,17942246 How long does it take when you run just the SQL statement in SQL Server Management Studio –Dustin Laine Mar 31 '10 at 7:01 1 minutes and 24 seconds –Avinash Mar 31 '10 at 7:43 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote accepted Instead of using a not in, use a left join: delete from tablename left join tablename2 on tablename2.fieldid = tablename.fieldid where tablename2.fieldid is null share|improve this answer answered Mar 31 '10 at 7:19 Guffa 444k57410725 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged sql-server-2005 asp-classic ado or ask your own question. asked 6 years ago viewed 2192 times active 4 years ago Related 2how to access sql server from asp page0SQL Timeout Errors0ADO showing “hidden columns” with SQL Native Client0authentic
your question and get tips & solutions from a community of 418,417 IT Pros & Developers. It's quick & easy. Timeout Error Question P: n/a David Berry Hi All. I have a SQL Statement on an ASP page that only returns 4 records. When I run it in SQL Server or Query Analyzer it runs in less than a second. When I run it from my ASP page I get: Microsoft OLE DB Provider for SQL Server error '80040e31' Timeout expired the error line points to the rs.Open sql,con line. The SQL Statement is: SELECT DISTINCT CUST_SERVICE.ACCTNO As Acct, CONT_DATE, SALES_REP_NAME, DESCRIP, PROD_TYPE, MODE FROM CUST_SERVICE CROSS JOIN CUSTOMER CROSS JOIN ORDERS WHERE (CUST_SERVICE.ACCTNO NOT IN (SELECT DISTINCT acctno FROM orders WHERE oredertype='Blowout Print' or oredertype='Print')) AND CONT_DATE BETWEEN '12/23/03'AND'12/24/03' AND SALES_REP_NAME = 'Anne' AND PROD_TYPE = 'P' AND CUSTOMER.BILLST = 'ct' AND ORDERS.oredertype = 'Print' ORDER BY CUST_SERVICE.ACCTNO Any ideas what could be causing this? I upped the Server.ScriptTimeout, Con.ConnectionTimeout and comCommand.CommandTimeout and nothing helps. Dave Jul 19 '05 #1 Post Reply Share this Question 11 Replies P: n/a John Blessing >>>>>>>>>>>>>>>>>> "David Berry"