Then I found out something interesting: I tried to execute the short SQL first, before the long update of the data field. Again, 6000 seconds (100 mins) is way too long before browser gives up. Religious supervisor wants to thank god in the acknowledgements What are the holes on the sides of a computer case frame for? Do the fields in your WHERE clause have indexes? -- John Blessing http://www.LbeHelpdesk.com - Help Desk software priced to suit all businesses http://www.free-helpdesk.com - Completely free help desk software ! check over here
You cannot send private messages. The post had been opened outside the subroutine by this simple code: Set RecSet = Conn.Execute("SELECT etc") I just added the following before calling the subroutine. I even tried changing the data to 12533 A's just to see if the actual data was causing the problem. I still feel you need to query the database asynchronously, and poll it to see if the results have been returned. -- Manohar Kamath Editor, .netWire www.dotnetwire.com "David Berry"
share|improve this answer answered Mar 19 '14 at 11:14 user3435078 134117 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign Edit 6: Have now attempted to update a different post in the same table: UPDATE [info] SET [confirmed]=0 WHERE [ID]=1; It also gave the timeout error. Didnt want to convert the whole thing to stored procedure because of the logic complexity. Join & Ask a Question Need Help in Real-Time?
Is there an easy way to check the row length?CheersStuart Kristen Test United Kingdom 22859 Posts Posted-07/14/2004: 04:04:35 The row length won't be the problem - SQL lets you I have no control over the database. I could be wrong). Query Timeout Expired Sql Server But for your info my script does a batch update on all the records, so it opens quite a lot of connection.
Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the Asp Microsoft Ole Db Provider For Sql Server Error 80040e31 What is the meaning of the phrase "in the hands of big money"? 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 Client0authentication to sql https://eedle.com/2010/11/13/i-was-working-on-an-asp-page-today-that-included-an-ajax-call-off-to-trigger-various-sql-updates-amongst-which-was-a-call-to/ I took it directly from the Cold Fusion.
But then, if the time to execute the > query is too long, your browser might just give up. Microsoft Ole Db Provider For Sql Server Query Timeout Expired Hi Manohar, Thanks! Bob Barrows David Berry wrote: Hi John, Yes, I need them and no, they don't have indexes. 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
Can this be patch related, or due to a setting on the IIS/Ms sql server/Windows 2003? Query Timeout expires0Error while deploying thee cube in SSDT SQL 20120Unable to access vbscript variable after using it in sql string - Variable is not null, but errors when used0Classic ASP Microsoft Ole Db Provider For Sql Server Error 80040e31 Timeout Expired Is it something in MS SQL server? Server Scripttimeout So for example just add CONT DATE at the end of your order by clause.
Sounds very much like a highly denormalized table that might benefit from a good dose of normalization .Cheers*##* *##* *##* *##* Chaos, Disorder and Panic ... check my blog You might shorten it to say 600 seconds. Display the results. -- Manohar Kamath Editor, .netWire www.dotnetwire.com "David Berry"
You may want to consider using an ISO standard date format, i.e. Here is the code that I use to execute the SQL on the ASP page: Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "Provider=SQL Server Native Client 11.0; Server=localhost;Database=databank;Uid=myuser;Pwd=mypassword;" Conn.Execute "UPDATE [info] SET [stamp]='2014-03-18 When I run it in SQL Server or Query Analyzer it runs in less than a second. this content Do the fields in your WHERE clause have indexes? -- John Blessing http://www.LbeHelpdesk.com - Help Desk software priced to suit all businesses http://www.free-helpdesk.com - Completely free help desk software !
You cannot delete your own topics. Microsoft Odbc Sql Server Driver Query Timeout Expired Kristen Test United Kingdom 22859 Posts Posted-07/14/2004: 08:03:22 I would suggest you kill the logs and try again. 300MB for a 50MB DB is a lot ...Are you doing But you have not said "NOT NULL" and I therefore assume that SQL is defaulting to "NULL" and in such a case I don't think it actually updates any rows.I suppose
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. All Rights Reserved. The shrink and his patient (Part 2) Did Donald Trump call Alicia Machado "Miss Piggy" and "Miss Housekeeping"? have a peek at these guys But apparently this type of record set did lock something on MS SQL Server 2012 because when I added these lines of code before executing the UPDATE SQL statement...
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. In addition, as a workaround, you could change the timeout period for the ODBC driver used by your website. I have set the CommandTimeout value at 60000 "conn.commandtimeout=60000" Still the connection times-out after 30 seconds. Featured Post Course: From Zero to Hero with Nodejs & MongoDB Promoted by Experts Exchange Interested in Node.js, but don't know where to start or how to learn it properly?
When I run it in SQL Server or Query Analyzer it runs in less than a second. Maybe try that?Otherwise, I have no idea why you'd get a timeout if the query runs as fast as you say.