System Down

[ReportingAnalyst]

Hi,

Every once in a while, the database is updated where the tables in our reporting database are dropped and updated with the application data.

When it is dropped, then I see the error message on my test ASP web site:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Employee'.

So is there a way where I can code some text somewhere in the ASP page where I show that the system is down and it will be back in 3 to 4 hours?

I have a dbconnect.asp which has the connection data. Is that the place where I can code it.

Any ideas welcome.

Thanks.

 

[DotNetGnat]

i would suggest you to take a look at the method provided in the following link:

http://www.4guysfromrolla.com/webtech/060399-1.shtml

let us know if you still have any questions...

-DNG

 

[ReportingAnalyst]

I did a response.redirect "System_Down.html" at the top of the DBConnect.asp page and shall comment it out whenever the system comes back up.

The link was useful. Shall use it for any error trapping within the ASP page.

Thanks.