IISRESET from web page

Hi Experts,
It happens quite often that my web page displays the error message below:

Provider error '8000ffff'
Catastrophic failure

The only way I can fix this is by resetting the IIS with the following command:
IISRESET

I am using Classic ASP.
I was wondering if the IIS could be reset automatically from the web page whenever the Catastrophic failure error appears.

Thank you for your help.
romsomIT DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
What type of connection string  and database are you using?  What time of info are you getting (just text or images/blobs??  

Is there a specific place in your code?  Just one page or random?


http://classicasp.aspfaq.com/general/why-do-i-get-8000ffff/8002802b-errors.html
0
romsomIT DeveloperAuthor Commented:
I get this error only when I return values from Teradata.
The query is quite complex and sometimes it causes the page time out. It's supposed to return real time data from different Data Warehouse tables.
This is the  connection string I'm using:
DSN=Teradata;DRIVER={Teradata};UID=ABCDEF;PWD=pw123456;Persist Security Info=True;
0
Paul MacDonaldDirector, Information SystemsCommented:
While it may be possible to do the IISReset from within the codebehind, it probably makes more sense to fix the problem.

As previously noted, is there any pattern to this behavior?  Is it daily?  Weekly?  Random?

Are there tasks being performed when the problem occurs?  Hitting a database?  Accessing an SSL page?  Etc...

What version of IIS are you running on?
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Paul MacDonaldDirector, Information SystemsCommented:
Perhaps if you specified a timeout for the query?

DSN=Teradata;DRIVER={Teradata};UID=ABCDEF;PWD=pw123456;Persist Security Info=True; default command timeout=60; Connection Timeout=60;

...or something like that?
0
romsomIT DeveloperAuthor Commented:
I've tried to increase the timeout but that didn't change the situation.
I get the Catastrophic Failure message about twice a month, but ironically almost always on my days off.
The page where the error message appears returns data from a Teradata database, and I guess it happens when too many users are querying the database at the same time.
I don't have codebehind, because I'm using Classic ASP. I am just curious if there is a piece of code that would automatically reset the IIS without me having to remote into the server and type IISRESET into the command prompt.
0
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
What about experimenting without using a DSN connection.

https://www.connectionstrings.com/ole-db-provider-for-teradata/
Provider=TDOLEDB;Data Source=myServerAddress;Persist Security Info=True;
User ID=myUsername;Password=myPassword;Session Mode=ANSI;

Open in new window

0
romsomIT DeveloperAuthor Commented:
I've tried the connections string but this is the error I get:

ADODB.Connection error '800a0e7a'

Provider cannot be found. It may not be properly installed.
0
Paul MacDonaldDirector, Information SystemsCommented:
I don't understand why an IISReset would fix a data access issue, other than to clear the error on the page itself.  A "Back" button could do that...

That said, can you try to trap the exception and re-run the query if the problem happens?

(Codebehind also refers to code inline...at least in this shop)
0
Big MontySenior Web Developer / CEO of ExchangeTree.org Commented:
to perform an actual IISRESET from an asp page, have your link or whatever go to an asp page with the following code in it:

<%
Server.CreateObject("WSCript.Shell").Run "cmd.exe /c iisreset /reboot"
%>

Open in new window


you may want to put it in its own folder with Anonymous access disabled if your site is a public site, otherwise anyone would be able to reset the site, and I'm guessing you don't want that :)

I agree with the others in this post, this is just a band aid to the problem, best to find the actual issue causing the problem....
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
romsomIT DeveloperAuthor Commented:
Thank you very much for your help and advise.
Fixing the problem makes more sense than just rebooting the server when it happens.
I've found some connections left open, maybe that's what caused the "Catastrophic Failure".
0
romsomIT DeveloperAuthor Commented:
I'm sorry; I meant to award the points equally for the three of you.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.