Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Lijo Cheeran Joseph
Posting Yak Master
123 Posts |
 Posted - 2011-07-21 : 08:49:16
|
| Hi,Our appliocation is using SQL Server 2005 as the database. We are getting the “Invalid attempt to call Read when reader is closed" in our application exactly after 10 minutes. I checked the DB server. It was set as 600 sec for the Remote Query Timeout. I changed as zero and restarted the server. Still the same error happens. Any other time related setting available? Any value default to 10 min (or 600 sec)? Please share your thoughtsThanksLijo |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-07-21 : 09:04:15
|
| Databases don't have timeouts, timeout is purely a client-side setting. Your application has a 10 minute timeout set somewhere in it. If you want to change it, it has to be changed from in the application.The Remote Query Timeout setting is purely and only for linked servers. Hence the 'remote' part of the name.--Gail ShawSQL Server MVP |
 |
|
|
Lijo Cheeran Joseph
Posting Yak Master
123 Posts |
Posted - 2011-07-21 : 09:19:06
|
| Thanks for the info. Yes, we are using a hsitory database to which the actual datbase is putting values using trigger. So can you please provide more input like which all values can be causing this problem?Note: We don't have this problem when we swtich off all the triggers.I have read the http://msdn.microsoft.com/en-us/library/ms177457(v=sql.90).aspx [ This value applies to an outgoing connection initiated by the Database Engine as a remote query. This value has no effect on queries received by the Database Engine.] |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-07-21 : 10:31:28
|
| Exactly "This value has no effect on queries received by the Database Engine." It's for linked server queries - queries across database server.Timeout is set in the client application, if you want to change it you have to change it in the client application.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Database Timeout Settings (10 min) Question