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 |
|
matt_calhoon
Posting Yak Master
235 Posts |
 Posted - 2000-11-21 : 19:40:20
|
| Hi there,Has anyone had a problem similar to this. I have a recordset that returns the name and id fields of a table in a SQL 7.0 database. Now when I click on the name field I go to an ASP page that will return all the columns for that record - these include images, text fields, varchar etc etc - simple stuff.Now my problem is that occasionaly some of these records just cant be retrieved via asp! So if I click on one particular record it just times out on the browser and wont let me view the record. to overcome this problem i have to reboot the server and then all is well for about a week until it starts doing it again.It is happening to a couple of databases.If I try to execute the same query using Query Analyser I get the results no worries.... I intially rebuilt the indexes but found that it wasnt the cause.Is there any other methods I can use on the SQL side to work out what is the problem? Or maybe it is an ASP problem with the DLL?Any ideas/help would be greatly appreciatedCheers - Matt |
|
|
|
|
|
Retrieving SQL records TIMES OUT from ASP