Ugh...timeout Error Driving Me Insane

Mar 28, 2006

ok here's the deal...

I've got 2 identical DB's on the same server, one production, one test. No we don't have a test env, but at least I'm not testing on a prod DB (some people here do, trust me).

I've got a prod VB6 app that used SQL sp's. I've pointed the ADO connection string to the test DB while I make the changes I need to make, and I'll obviously change it back before I'm done etc.

I made some VERY minor changes to one of the sp's (added a variable, changed some stuff), tested thoroughly in query analyzer (runs with no errors in <1 sec), altered my ADO command accordingly and when I executed I get this:

run time error '-2147217871 (80040e31):
[Microsoft][ODBC SQL Server Driver] timeout expired

The connection to the server is fine, I've tested that - it trips on the execution of the command:

Set rstCalls = conHelpArchiveConnection.Execute(SQLQ)

so here's my question: The prod version of this app works like a charm, and the test app times out. I'd rather not toy with the connection timeout setting on the server. Any thoughts on what could be causing this?

Any help would be appreciated, I'm ready to throw in the towel. Well at least until tomorrow morning ;)

View 7 Replies


ADVERTISEMENT

CURSOR Is Driving Me Insane!!

Jan 13, 2007

We have a tree structure containing section names.  Each node is a
section name and each section can have subsections.  I have to copy the
tree structure but need to maintain the parent-child relationship
established within the id / parent_id fields.  How do i acheive this?For example i have the treeSection 1   |-Section 1.1Section 2   |-Section 2.1The
"Section" table contains 3 fields: id, parent_id, and caption.  ID is
the identity of the section record and parent_id contains NULL or the
ID of this record's parent to create a child.  So "Section 1" (id=1,
parent_id=null), "Section 2" (id=2, parent_id=null), "Section 1.1"
(id=3, parent_id=1), "Section 2.1" (id=4,parent_id=2).I would
like to copy this sucture to create 4 new sections but they need to
maintain their id/parent_id relationships BUT with new IDs.  For this i
created the following stored procedure:----------------CREATE PROCEDURE [dbo].[CopySection] AS     -- Declare a temporary variable table for storing the sections     DECLARE @tblSection TABLE     (          id int,          parent_id int,          caption varchar(max),     )     DECLARE @newAgendaID int, @newSectionID int;     DECLARE     @tid int, @tparent_id int, @tcaption varchar(max);BEGIN     -- SET NOCOUNT ON added to prevent extra result sets from     -- interfering with SELECT statements.     SET NOCOUNT ON;     -- Copy the desired sections into the local temp variable table     INSERT INTO @tblSection SELECT id, parent_id, caption FROM tblSection ORDER BY parent_id;     -- Using a cursor, step through all temp sections and add them to the tblSection but note its new ID     DECLARE c1 CURSOR FOR SELECT * FROM @tblSection ORDER BY parent_id FOR UPDATE OF parent_id;     OPEN c1;     FETCH NEXT FROM c1 INTO @tid, @tparent_id, @tcaption;     WHILE @@FETCH_STATUS = 0     BEGIN                   -- Insert the new Section and record the identity          INSERT INTO tblSection (agenda_id, parent_id, caption) VALUES (@tparent_id, @tcaption);           SET @newSectionID = SCOPE_IDENTITY();          -- Update the temp variable table with the new identity from the newly created real section in tblSection                -- Update all temp variable records to point to the new parent_id          UPDATE @tblSection SET parent_id = @newSectionID WHERE parent_id = @tid;          FETCH NEXT FROM c1 INTO @tid, @tparent_id, @tcaption;     END     CLOSE c1     DEALLOCATE c1     END----------------The
critical "UPDATE @tblSection" part doesnt seem to update the temp
variable table with the @newSectionID (the actual section identity
obtained after inserting a real record into the tblSection table).  So
in the end the inserted records into tblSection still point to the
incorrect parent_id instead of the copied record's parent_id.Maybe I'm using CURSOR incorrectly or not setting a parameter so that it refreshes its recordset?  I've tried using both table variables and temp tables but no luck.

View 2 Replies View Related

DTS Error Problems Driving Me Mad!!!!

Sep 8, 2004

I have a DTS scheduled to run daily. It has run OK for the past few months, but now always fails, the following error appears:

dtsrun.exe - application error

the instruction at 'xxxxxxx' referenced memory at 'yyyyyyy'. The memory could not be 'read'. click on ok to terminate the program.


The dts itself runs fine if started manually, but always fails as a scheduled job, even if its started manually.

Help!!!!!

View 2 Replies View Related

Syntax Error - Driving Me Crazy

Nov 29, 2007

Hi Guys,    I have a syntax error in my SQL SELECT Query that is driving me crazy. All I am doing is adding a conditional with a literal value and that is breaking the query.This Query Works: SELECT
Quantity,
CAST(Gallons AS VARCHAR(10)) + ' ' + Style,
Colour
FROM
ORDER_TANK_LINK
LEFT JOIN TANKS
ON TANKS.TankID = ORDER_TANK_LINK.TankID
LEFT JOIN COLOURS
ON COLOURS.ColourID = ORDER_TANK_LINK.ColourID
 This One is Broken:SELECT
Quantity,
CAST(Gallons AS VARCHAR(10)) + ' ' + Style,
Colour
FROM
ORDER_TANK_LINK
ON ORDER_TANK_LINK.OrderID = 1
LEFT JOIN TANKS
ON TANKS.TankID = ORDER_TANK_LINK.TankID
LEFT JOIN COLOURS
ON COLOURS.ColourID = ORDER_TANK_LINK.ColourID
 Obviously I haven't explained the design of the tables, but because of the fact that I have another query that is so similar working perfectly, I didn't think you'd need it.
The exact error is "Incorrect Syntax Near the Keyword 'ON'". OrderID is definately a value of the ORDER_TANK_LINK Table and is of type int.
Thanks in advance!

View 4 Replies View Related

Driving Me Nuts: Error: 18456, Severity: 14, State: 16.

Oct 16, 2007

Hello,

I'm currently evaluating Visual Studio Team System using SQL Server 2005 (9.00.3042.00, SP2, Enterprise Evaluation Edition) and from time to time, I get this error:


Error: 18456, Severity: 14, State: 16.

If I try to connect to the database using SQL Server Management Studio, I get the error:

"A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP provider, error: 0 - An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054)".

If I restart the SQL Server services, everything works fine! This is driving me nuts!

Additional information:
- The user accounts and security are OK - they have been double checked, and once the services are restarted everything works fine.
- SQL Server is configured to accept remote connections - again, once the services are restarted eveything works fine.
- I have disabled meanwhile the following protocols: VIA, Named Pipes, Shared Memory both at the Server and Client - and the problem still remains.

Any help?

Thanks!
João

View 2 Replies View Related

Error : Timeout Expired. The Timeout Period Elapsed Prior To Completion Of The Operation Or The Server Is Not Responding.

Jul 3, 2007

Hi,
I am running a stored procedure that collects some records from two tables do some calculations with those records and insert those calculation result in a temp. table. I am calling this stored procedure in my aspx page and then later select all the records from temp table and show it in a table.
When I run this application on browser it give me Timeout expired error but whn I execute the stored procedure it runs properly but takes around 3:10 mins to execute in query analyzer. I did some google work and based on that I specified CommandTimeout = 300 for SP and Connection timeout=400 in web.config. But still it didnt worked. Sometimes it runs properly but sometimes its not.
Where I am doing mistake? and Wht should i do to resolve this? Plz. help.
Thanks in adv.
Regards,
Yogita
 
 

View 1 Replies View Related

Error: Timeout Expired. The Timeout Period Elapsed Prior To Completion Of The Operation Or The Server Is Not Responding.

Dec 26, 2007

Guys,
I am trying to attach a database object to the App_Data directory I got thie error
  Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
This is what I did. I right click the App_Data folder and click Add New Item. Then I click the SQL Database. This is where I got the error.
What should I do? Please help

View 2 Replies View Related

Error : Timeout Expired. The Timeout Period Elapsed...

Nov 10, 2006

Hi,I
get this error from our web application every once in a while. " Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding". I email
myself when an error occurs, and once every 2-3 days I get this timeout
error emails, like 5-10 emails in a span of few minutes. Then it goes
away. I have set the command timeout for 60 secs.
It
doesn't happen from the same stored procedure, actually I have seen it
timeout from really simple 1 or 2 line stored procedures, which shouldn't normally take 1 sec. Its like
sql server just shuts down for few minutes. We have some
backups and maintenance jobs scheduled, but they run only after
midnight. I have checked the
application event viewer, there are no warnings or
error messages for MSSQLSERVER. Can
any one tell me how to check whats going on during that short timespan
when timeout error occurs, and what causes it? I don't want to run sql
profiler continuously for 2-3 days, I am afraid it will slow down the
server more. Thanks.

View 3 Replies View Related

Replicate Every 15 Minutes: Insane?

Jan 15, 2008

The company I work for has no experience with replication, and neither have I.
Now I recieved a functional specifications document and apparently what they want is use replication to maintain a copy of a production database on the data warehouse server.
The database is 70GB, and they want to do it every 15 minutes (so their reports will contain up-to-date data).

As I said, I know nothing about replication, but to me, this sounds like madness. I fear that this will will (at least) have a negative impact on the performance of the production database.

So is it possible? Does replication have a big impact on the database or is it hardly noticable? I expect about 500 new records every 15 minutes; production database and data warehouse are on different servers; both are SQL2005.

View 6 Replies View Related

Vista Is Going To Drive Me Insane With SQL

Oct 26, 2007

I upgraded to Vista last week. I immediately lost complete access to SQL Server 2000 (screw the money it cost to buy, I'm past that now). Now I CANNOT access my data!!!!!!!!!!!!!!

How the heck do I install SQL Server Express on a laptop with Vista. It has a dual core intel chip. I have installed/uninstalled every f'ing SQL Server Express out there. I keep getting an error about not allowing remote connections so (error 26). I can't take anymore. I've spent 3 days on this problem.

Can someone give me a link for a download or at least tell me how to get SQL up and running. I need my data!!!!!!!!!!!!!! I need my applications!!!!!!!!!!!!

I'm about to just go out and buy a new computer.

View 4 Replies View Related

Xp_sendmail Driving Me Mad !

Jan 11, 2002

Has anyone else noticed that if you create a non-existing file as an attachment using xp_sendmail in SQL Server 2000, it does not create a copy of that file on the Hard Drive, nor does it format the attached file sensibly if you attach it as a .csv file ?

I am using the procedure below :-

CREATE PROCEDURE mailtest AS

declare @sql varchar (255)

SELECT PERSONID, FORENAME, SURNAME INTO ##TEMP FROM PERSON

SELECT @sql='SELECT * FROM ##TEMP'

IF @@ROWCOUNT > 0

begin

exec master.dbo.xp_sendmail
@recipients = 'itsmarkdavies@hotmail.com',
@Message = 'Test file',
@Query = @sql,
@attachments = 'C:MARKTEST.CSV',
@Attach_Results = 'True',
@Message = '',
@Subject = 'test',
@No_Header = 'True',
@Width = 500,
@Separator = ','

end
DROP TABLE ##TEMP
GO

In the example above, the file MARKTEST.CSV does not currently exist, but the procedure should create it, put it in the root of C: and e:mail it, as it did when it ran under SQL Server 6.5. However, under 2000 it now doesn`t put a copy on the Hard Drive and it formats the .csv file in a very odd manner.

View 1 Replies View Related

Error = -2147467259 (80004005) Error String: Timeout Expired

May 5, 2003

Hi everybody,
I do custom log shipping over network like

step 1 backup log to C:..
step 2 zip log file c:... zip
step 3 copy zip to \sm01
estorelogs...
step 4 unzip file
step 5 restore log with stand by

Few times a month it fails with

Error = -2147467259 (80004005) Error string: Timeout expired Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: Timeout expired Error source: Microsoft OLE DB Provider for SQL Server

Any idea ,what might cause it ?

Thank you
Alex

View 3 Replies View Related

[298] SQLServer Error: 258, TCP Provider: Timeout Error [258]. [SQLSTATE 08001]

Mar 11, 2008

I've received this error twice over 2 days in the SQL Agent error log during off-hours from a server which has not had any changes to it in the last few months (once at 3:32AM and the next day at 3:46AM. I've been able to tie it to log-shipping backup jobs (all of which run under the SQL Service domain account) which run every minute. It seems to be only momentary, as the next attempt a minute later is successful.

I get the same set of messages for each database for the same time which look like this:


Date 07.03.2008 3:31:51 AM
Log SQL Agent (Current - 10.03.2008 6:15:00 PM)

Message
[298] SQLServer Error: 258, TCP Provider: Timeout error [258]. [SQLSTATE 08001]

Date 07.03.2008 3:31:52 AM
Log SQL Agent (Current - 10.03.2008 6:15:00 PM)
Message
[165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]


Date 07.03.2008 3:31:52 AM
Log SQL Agent (Current - 10.03.2008 6:15:00 PM)

Message
[298] SQLServer Error: 258, Unable to complete login process due to delay in login response [SQLSTATE 08001]


Date 07.03.2008 3:31:52 AM
Log SQL Agent (Current - 10.03.2008 6:15:00 PM)

Message
[382] Logon to server '(local)' failed (SubSystemStepHistoryLogger)


I can't find any documentation on these errors on the web or MSDN site. Can I chalk this up to possibly "winking" connection to our domain controller? We've never had these messages before, and our LAN department swears that there have been no upgrades to the network or domain controller servers recently.

View 25 Replies View Related

Timeout Expired Error - SQL Server 2005 Error After Exactly 1 Hour

Aug 27, 2007

We have several large government web sites that we help look after. We recently migrated one of them from SQL Server 2000 to 2005 and are having a problem with our nightly email job in that if it runs for more than an hour then after exactly 1 hour the email job gets a "Timeout expired" message back from SQL Server.

Our batch jobs do run on a different server and connect remotely to our SQL Server DB. I did change the connections - remote query timeout and increased it 10 fold, but this didn't make any difference. Is there any other parameter that may be causing the Timeout expired error after exactly 1 hour?

Thanks !

View 1 Replies View Related

Sp_processmail - Driving Me Nuts!

Apr 2, 2004

I have two different SQL server installations (7 and 2000) that I have configured for using the SP_processmail procedure. Both servers can properly execute xp_startmail, xp_stopmail, xp_readmail, and xp_findnextmsg. HOWEVER, both have different problems with SP_processmail.

Using this command (and a host of many other variations):
sp_processmail @filetype = 'CSV', @separator = ',', @dbuse = 'ryantest', @set_user = 'guest'

SQL 7.0 says: Server: Msg 18007, Level 16, State 1, Line 0
Supplied datatype for @set_user is not allowed, expecting 'varchar'

I have tried every variation possible, including not specifying the yser which should result in it defaulting to the "guest" account. The message is always the same.

SQL 2000 says: Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x80004005
Queries processed: 0.

I have checked all my configurations and read every KB article - I can't find anything wrong.

Can someone PLEASE respond if you have any experience with SP_PROCESSMAIL on your servers.

Thanks in advance.

Ryan Hunt

View 1 Replies View Related

Math Is Driving Me Nuts

Jul 20, 2005

The business rule is, the sales manager is commissioned on the avg. numberof appointments set up per salesrep per day during the month.I have 2 tables: The UserLog table records only 1 entry per day per user(salesrep). This will log how many salesreps worked a particular day. Thesecond table logs any appointments set up.UserLog: ID, UserName, EnteredTimeAppointment: ApptID, EnteredTime, ApptDateI figured that, for a given date ranged, I could1. sum the number of appointments2. sum the number of days worked2. sum the salesreps / number of days = avg number of salesreps per day3. number of appointments / avg number of salesreps per day = avg numberof appointments per sales repBut this logic is flawed. If I average out every day and then take anaverage of this daily average, I get a different result. Any ideas on howto best solve this problem?Thanks.

View 7 Replies View Related

Parameterized Query Driving Me Crazy

Apr 16, 2008

I'm trying to do a basic update query which is working on other pages but not on this page.  Dim uid As Integer = CInt(Session("uid"))
Dim cmd As New SqlCommand("UPDATE [cvdata] SET [jobCompanyName] = @inputJobCompanyName WHERE [user_id] = @uid", strConn)
With cmd.Parameters
cmd.Parameters.AddWithValue("@inputJobCompanyName", inputJobCompanyName.Text)
cmd.Parameters.AddWithValue("@uid", uid)
End With
cmd.Connection.Open()
cmd.ExecuteNonQuery()
cmd.Connection.Close()
The funny thing is that if i remove inputJobCompanyName.Text and add a custom value (for example "test") it works.So it doesn't seem to read my updated textfield or something im clueless.Kind regards,
Mark

View 2 Replies View Related

This Is Driving Me Nuts - Solicit Help From The Gurus

Jul 20, 2005

Hi -I hope some one can help me with this.I am using sql server 2000[Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 200316:08:15 Copyright (c) 1988-2003 Microsoft Corporation EnterpriseEdition on Windows NT 5.0 (Build 2195: Service Pack 4)]I have a stored procedure that is using cursors and a few joins, andwrites to a few tables. (I can post the code if that will help) Thestored procedure takes approximately 27 seconds to complete whenexecuted inside query analyser. However, if I run the stored proceduresource directly inside query analyser (like a long sql script), ittakes only 3 seconds!! These results are consistent and reproducible.I would think a stored procedure stores the plan, and I would expectbetter optimization. Why am I witnessing the opposite behaviour? Anyone has any experience?The server is manned by DBAs (I work at a large corporation), so Ibelieve it is well configured. We have noticed similar behaviour ondata restores on a different physical server.Thanks in advance,-praty77

View 6 Replies View Related

Simple IIF Statement Driving Me Nuts

Oct 17, 2007



I have an IIF statement in a text box. Its very basic

What I want is to check if the value of something is greater than 1. If it is, then make it 1. If it isn't then just use what the value is.

(loose example)

=IIF((Field!Var1.Value * Field!Var2.Value)>1, 1,Nothing)

Basically I can't have a pecentage greater than 100. If it is then make it 100. If its not then just use the result of the calculation.

View 7 Replies View Related

DTS Export Wizard - Simple Question Driving Me Mad!

Dec 6, 2000

Where does sql server store the server names that show up in the drop down list for choosing a source or destination server?

View 3 Replies View Related

Driving SSIS Packages From ASP.NET Web Services...is It Thread-safe?

Jun 10, 2007

Our application drives SSIS packages from ASP.NET web services. To alleviate some of the package load time overhead application caches SSIS Application object and several instances of "pre-loaded" packages in ASP.NET Application context. As needed the code uses cached SSIS Application instance to execute "pre-loaded" packages. Is this thread-safe?

View 10 Replies View Related

Timeout Error

Apr 18, 2008

Hi All,I’m connecting to a database through a connection string <add name="ConStr"   connectionString="Data Source=KXXX1-SQL;Initial Catalog=ROOTDATA.MDF;Integrated Security=SSPI;connection timeout=0"   providerName="System.Data.SqlClient"/> but I’m getting the following error Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding I know this was handled previously in this forum and the remark was to set CommandTimeout = 0 How do I do that?
 

View 9 Replies View Related

TimeOut Error

Feb 2, 2004

User r complaining tht they sometimes get SQLServer Timeout error.

on investigating i found tht suppose one user is updating the database which is taking some time and at the same time if another user tries to retrieve some data from the database he gets a timeout error after some time...........

However if the updateor insert action get over very quickly then the other user is able to retrieve the data ........

Is it bcoz tht the update statements r locking the datatables during the opperation and so the other user has to wait.. if tht is the case then wat is solution tht the other can retrieve the data without much waiting while one user is updating ........

View 3 Replies View Related

Timeout Error

Sep 5, 2000

I have to maintain a visual basic application. This application basically runs a report for whole month(30 days). If I run it for more than 5 days, it gives me a sql server timeout error. Where should I check connection timeout property on sql server? Please help..

View 1 Replies View Related

Timeout Error

Jul 30, 2007

Hi,
We were in the process of migrating our application from sql 2000 to sql 2005.
It is noticed that a particular method is giving us Timeout Expired error in SQL 2005 €“ Sp2, windows 2003 server sp1.
It was working perfectly in SQL 2000 and SQL 2005 (without any Service Packs)
After we installed the Service pack 2, the method call from Sqlhelper class

€œSqlCommandBuilder.DeriveParameters() €œ is giving the time out error.

We tried a round work by installing SP1 first and then installing a support patch from the following url
http://support.microsoft.com/kb/917824 but still the method is giving the same error.


any kind of help will be greatfull.

Regards
Mat

View 1 Replies View Related

SQL Server 2005 And Management Studio Driving Me CRAZY -Im UPGRADING To 2000

Feb 2, 2006

Is it just me, or are features missing in Management Studio? I mean, where is the "Export Objects" option when exporting data? Why is it so difficult to register a remote server? Why do the object views suck? And most important, why is the documentation  the worst software documentation I have EVER SEEN?!
Things that were easy in Enterprise Manager with Client Network Utility and Query Analyzer seem impossible, difficult, or maybe just hidden in Management Studio. If it is there, the documentation sure doesnt tell you how to find it.
Please someone tell me that it's just me. Tell me that the features are there but Im not doing something right. I feel like putting my head in between my door opening and banging the door against it.

View 2 Replies View Related

TRIGGER: Help With 2 IFTHEN Statements Driving Multiple Inserts Into B_items Table...

Jul 30, 2007

Assuming I should be using values from temp inserted to insure correct record...
Need help coding IF...THEN INSERT statements in following After TRIGGER:

Create TRIGGER trg_insertItemRows

ON dbo.a_form
AFTER INSERT

AS
SET NOCOUNT ON
-- Checkbox Driven:
IF a_form.missingCheckbox = -1 THEN
Insert into b_items (form_ID, parent_ID, ItemTitle)
Values (Select Distinct i.form_ID,i.parent_ID from inserted i)', '+ 'User checked Missing Data')

-- Textbox Driven:
IF a_form.incorrectTxtbox <> 'na' THEN
Insert into b_items (form_ID, parent_ID, ItemTitle)
Values (Select Distinct i.form_ID,i.parent_ID from inserted i)', '+ Correction: Replace '+ incorrectTxtbox + ' with '+replaceWithTxtbox)


Sample code below:

-- Source table the Trigger acts on
Create Table a_form (
form_ID int Not Null,
parent_ID int,
missingCheckbox bit,
missingNote varchar(100),
incorrectTxtbox varchar(50),
replaceWithTxtbox varchar(50)
)

--Target table Trigger inserts into
Create Table b_items (
items_ID int Not Null,
form_ID int Not Null,
parent_ID int,
ItemTitle varchar(150)
)

View 5 Replies View Related

Error: Timeout Expired

Sep 2, 2006

I have an Update stored procedure that is used to update four tables at the same time. The issue is that it works perfect when i run the application in local  server,but when i upload the application on to the server that is located in U.S, it gives an error "System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed
prior to completion of the operation or the server is not responding. " I think the sqlCommand is timing out and the value is not returned. Is there a workaround to this issue? What could be the reason for this? Any ideas.. Please help..  

View 5 Replies View Related

Getting A Pool Timeout Error

Sep 8, 2007

I have pages which are using a master page.
An example page on my site would be the homepage, it makes 3 connections to mssql.
1) Get the keywords of the page
2) Get a list of news articles
3) Get the content of the page.
 When I visual web express to debug the site it's giving me a pool error message, neither can I get the site to load directly via IIS. It says theres been a pool timeout.
I've read on the internet about making sure connections are closed when you are finished and I've checked that all database connections are closed using
finally{conn.Close();}
 does anyone have any idea why I would be having this problem?
How can I see what connections the site is opening, or maybe theres a limit on my server?
I'm using my own test server running windows 2003 and IIS

View 6 Replies View Related

Timeout Expired Error

Feb 15, 2008

Hi:
Just purchased a web application, sometime it will cause the timeout error, that will cause the web page can't be opened, and popup an error page."Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding."
The function is below:public static ProfileAnswer[] FetchNonApproved()
{
using (SqlConnection conn = Config.DB.Open())
{
SqlDataReader reader = SqlHelper.ExecuteReader(conn,"FetchNonApprovedAnswers"); //this is the line where the timeout error occurs.

List lAnswers = new List();

while (reader.Read())
{
//do something here
lAnswers.Add(answer);
}

return lAnswers.ToArray();
}
}

 Is there anyway to jump out of the error if the timeout occurs, abort the further action, and back to current page.  (what is the problem with the code?)
Thanks a lot.
Jt

View 1 Replies View Related

Timeout Expired Error

Oct 11, 2004

Hi;

I am getting this error sometimes what can I do for this

Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.

thank you...

View 2 Replies View Related

SQL Connection Timeout Error

Nov 18, 2004

hi, all
These days i met a problem regarding a SQL connection.

i try to create an ODBC to a SQL server, and everytime a prompt of timeout error appear. Detailly it is that...connection failure,SQLState:'HYT00'...
i am sure the logon username and password are right... and i can make it in some machines, but it is surprised that i got failure on the other machines(a error appear just like what i mention above)...i don't know how... i guess something wrong in those machines error showed.

Please help me.

Thx

View 1 Replies View Related

TimeOut Expired Error

Apr 14, 2006

My application always face timeout expired error (as following) whenever i first run the application. But it can run well for second time.
Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 
 
Is there any suggestion or advice for me about this problem? Thank You. 

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved