I have a problem that has popped up on several pages on my site that connect to a SQL 7 database. Result sets are only returning 3 or 4 rows on queries that should have returned 100+. These are pages that have worked flawlessly in the past, and only recently started exhibiting this behavior.
If I restart the server, the behavior will disappear for a half hour or so, and then reappear. I also tried extending the asp script timeout which did basically the same thing as restarting the server.
I don't get any error messages at all, just a truncated dataset.
Any help or suggestions would be greatly appreciated!
Thanks,
Peter
pyerwoh@hotmail.com
Peter Pedersen
Developer, Infomission.com
If I restart the server, the behavior will disappear for a half hour or so, and then reappear. I also tried extending the asp script timeout which did basically the same thing as restarting the server.
I don't get any error messages at all, just a truncated dataset.
Any help or suggestions would be greatly appreciated!
Thanks,
Peter
pyerwoh@hotmail.com
Peter Pedersen
Developer, Infomission.com