database cannot be found

[reubenb]

is it possible in a database include file, to when there is a 'database not found' error, to redirect a user to another page?

thx

[TheShaner]

Yes, you the On Error Resume Next command right before where this error would occur (which is where you attempt to connect to the db). Like so:

On Error Resume Next
'Attempt DB Connection
If Err.Number <> 0 Then
'Redirect user here
End If

This is using VBScript of course.

-Shane

[reubenb]

It dosen't work, it just times out?

[TheShaner]

Where did you put the error catching? In the include file or the page with the include? Try both places and see if either works. Other than that, no idea.

-Shane

[reubenb]

in a function in the include file..
doesn't wrk/

[neocool00]

I believe that if you put it in a function, it will only work in that function.

[reubenb]

its a create db connection function though?

[neocool00]

Sorry, should have explained better (or maybe I mis-interpreted your reply). You should put the On Error Resume Next at the beginning of the function that opens the database. When I originally read your message, I was thinking that you had put the error checking code in a seperate function.