C
Chris Wertman
I have an ASP.NET page that does a query to my Sql2000 Server Running
on Windows 2003 Server Enterprise. I have 3 nearly Identiacl pages
that all execute different Queries on the DB it is a fairly complex
set of queries , Now a week ago all 3 worked fine.
BUT this week only 1 the simplelest works.
On the others I get a System.Data.OleDb.OleDbException: Timeout
Expired
I have Connection timeout set to 0 in the connection string, and like
I said it all worked a week ago, there is no difference in the data it
worked with a week ago and now,Ive tried it with an absurdly long
timeout and with no timeout set at all. Iv rebooted checked the
machine for process that may be consuming resources that werent. and
on and on
I dont even really care WHY its happening I ONLY care about HOW TO
RESOLVE it.
Unfortunatley I looked through usenet archive and while i have seen
people with the same problem I see no response on workarounds.
Sql and Windows 2003 are all patched up to current.
Previously I was getting timeouts on the ASP page itself as as part of
the process it writes about 50,000 pages out based on the data, then I
increased the timeout in the machine.config and that solved that, as
it should but NOW Im getting SQL timeouts on everything but the
simplest query.
Someone PLEASE help me on this otherwise Im going to have to scrap all
this and rewite it in PHP using MySQL and I dont really feel like
doing that. I just spent a fair bit of time converting it and
upgrading (if thats what it can be called) to .Net
The batch import of the data into MySQL was painfull thats why I went
to MSSQL and .Net to say the least and what really get me is IT
FRIGGIN WORKED FINE LAST WEEK ! None of that matters much I guess if
it wont run right under .Net and SQL
HELP HELP HELP !
Chris
on Windows 2003 Server Enterprise. I have 3 nearly Identiacl pages
that all execute different Queries on the DB it is a fairly complex
set of queries , Now a week ago all 3 worked fine.
BUT this week only 1 the simplelest works.
On the others I get a System.Data.OleDb.OleDbException: Timeout
Expired
I have Connection timeout set to 0 in the connection string, and like
I said it all worked a week ago, there is no difference in the data it
worked with a week ago and now,Ive tried it with an absurdly long
timeout and with no timeout set at all. Iv rebooted checked the
machine for process that may be consuming resources that werent. and
on and on
I dont even really care WHY its happening I ONLY care about HOW TO
RESOLVE it.
Unfortunatley I looked through usenet archive and while i have seen
people with the same problem I see no response on workarounds.
Sql and Windows 2003 are all patched up to current.
Previously I was getting timeouts on the ASP page itself as as part of
the process it writes about 50,000 pages out based on the data, then I
increased the timeout in the machine.config and that solved that, as
it should but NOW Im getting SQL timeouts on everything but the
simplest query.
Someone PLEASE help me on this otherwise Im going to have to scrap all
this and rewite it in PHP using MySQL and I dont really feel like
doing that. I just spent a fair bit of time converting it and
upgrading (if thats what it can be called) to .Net
The batch import of the data into MySQL was painfull thats why I went
to MSSQL and .Net to say the least and what really get me is IT
FRIGGIN WORKED FINE LAST WEEK ! None of that matters much I guess if
it wont run right under .Net and SQL
HELP HELP HELP !
Chris