IIS Log / Custom Error Database Discrepancies
We currently have custom error logging setup on all of our websites. We
have IIS setup to redirect to our custom 500-100.asp page which logs the
error to a database and then redirects to a friendly error message page.
Last week we were working on a pretty troublesome error on our intranet site
and noticed huge discrepencies between the IIS Log and our error log
database. On this particular day for this particular site, the IIS Log has
literally thousands more errors logged than our database does.
I am very familiar with ASP error logging and completely understand how our
current system is working. I've been given the task of figuring out why
there are more errors in the IIS Logs than in our "dbSiteErrorLog" database,
the destination db of our custom 500-100 page.
View Replies
ADVERTISEMENT
When you have a custom HTTP 500 error handler, how do you go about making sure all your previously opened recordsets/objects/connections/etc.are closed properly?
It would seem to me that once you hit a 500 error, you have no opportunity to close any of the previously opened objects, eventually causing memory leaks.
View Replies
View Related
I have an .ASP page with a form on it, which I want the info input into the form to be submitted to a database. I am trying to create a Custom Connection String in Dreamweaver but I am having a hard time. I set the path correctly, etc.
Is it not working because I am trying to run this with an Access database and it's on a Linux server? I thought i'd start out simple before I post a million pages of details.
View Replies
View Related
When a user tries to visit a non-existant page in our web site they receive a custom 404 error message. I want to capture the URL the user tried to visit. Does anyone know where I can find this string?
View Replies
View Related
I am still in the debugging of my website, but I'm nearing the end. As a last phase implementation, I want to be able to catch all asp errors and if there is one, send the user to a custom "sorry bout that" page, rather than having the errors displayed on that; if there aren't any errors, let the page load.
I setup the 404 error, but that doesn't seem to accomplish what I want.
View Replies
View Related
On windows xp we can modify 500-100.asp file for custom asp error messages. How can we do this on a windows NT 4.0 and IIS.or what is the similar file on NT and IIS?
View Replies
View Related
is there a way to make custom error pages specific to a particular page?I know you can make customer error pages for iis to use.but if there is an error on a particuar page, can i make a custom error page to be redirected to?
for example,if a user is clicking away and runs into an error,it would display error1.htm.if they were on a different page and an error occured,they would get an error2.hm.
View Replies
View Related
Just a quick question about making a custom error handler. Can I use. Code:
<%On Error Response.Redirect("error.asp")%>
instead of defining a custom error page in IIS? My site is hosted by an ISP so doing the latter would leave me completely without error messages; my way I could comment out the On Error code when debugging.
View Replies
View Related
why I can't use custom error messages with the asp extension in IIS5.1? I have set up a custom page to handle errors called errorHandler.asp and all HTML is rendered but not the asp.
If i put Hello World in the html body section it renders but if I put the same in a response.write of the asp it won't render.
View Replies
View Related
I have created a custom error page using asp. When I upload it to my site to test that it works, it appears to run fine. I have set it up so that an email would be sent to me if there is a page that can not be found. I first tested the page to make sure an email would be sent to me and it works.
Then I made sure that my server variables where be queried by printing them to the screen. But when I go in to IIS to point the 404 error to my new page and test it, the page is processed like straight html and not as an asp page.
View Replies
View Related
i have looked around on google and on here but cant find a decent example of making a custom 500 error page. I want an example that i can look at and unserstand then amend for my own needs (ie emailing the errors etc).
Can someone point me in the right direction?
View Replies
View Related
I set up a custom error 404 page as URL and it works sometimes but not always. The problem is when the URL contains special characters, like [ or : , it produces the error message:
The system cannot find the file specified. and nothing else. The response code is 404, and it does not contain any other info in the response header. The server is IIS5.
The odd thing about this problem is that it happens on only one server that I am aware of. Most of my clients do not have this problem, so I suspect that this is a server related issue instead of coding issue. What can possibly cause this problem?
View Replies
View Related
I have a site that currently has custom error messages enabled for all error messages, i.e. any error goes directly to error.asp etc. What I want to do however is have this error.asp email me with a fairly detailed error message outlining the problem that caused the error.
What is the best way of doing this? My server allows me to setup custom messages for any type of error but obviously to do this would be time consuming. Is there a way I can basically email myself an almost exact copy of the error message that I would get if I was viewing the page and the error happened to me?
For example, a 501.100 error can cover any number of error and whereas a message telling me that a person got a 501.100 at 12.43 on 31/5/2004 is ok it isn't very helpful. I want it to say:
501.100 at 12.43 on 31/5/2004
Error Type:
Microsoft VBScript compilation (0x800A03F9)
Expected 'Then'
/kshs/cms/cmsDefault.asp, line 54, column 39
View Replies
View Related
I have a custom 404 error page. When I change my site properties in IIS (IIS 5.0, BTW) to point to a file, I still get the original 404 error page. But, then I copied my error page to my root, then pointed to it via URL and it works! BUT, I would prefer to use the file page instead of the URL.
View Replies
View Related
I have 404.asp file that catches non existing pages such as www.site.com/es for spanish version of site. Now I would like to move ahead and have es.site.com instead. I started digging into subdomains in IIS and found out that usually when creating subdomain in IIS it creates a separate sub-directory by the same name as the subdomain created. From some reason the custom error 404.asp file I already have is not called when a call to a non existing sub domain page is made.
Anyone knows why?
How do I configure 404.asp to also handle subdomain page requests?
I know that in Unix/Apache I can use .htaccess file to direct calls to es.site.com to www.site.com/es quite easily, can this be done somehow on IIS?
View Replies
View Related
I have just started using ASP, I am normaly using PHP but I thought ASP might be a good road to go down. I am having a few problems, I am trying to limit the number of records I take out the database but I keep getting errors.
<%
'connection string
datapath=Server.Mappath("guest.mdb")
strconn="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & datapath & ";"
Set CONN = Server.CreateObject("ADODB.Connection")
CONN.Open strconn
'select all records row by row
DBquery="SELECT * FROM Guests LIMIT 10"
set query=Conn.execute(DBquery)
do while not query.eof
'get a variable from the table
guest_id = query("ID")
guest_name = query("Name")
guest_msg = query("Mesg")
guest_date = query("DateTime")
'print the variable to the screen
response.write guest_id & "<br />"
response.write guest_name & "<br />"
response.write guest_msg & "<br />"
response.write guest_date & "<br />"
response.write "<br />"
'move to the next record
set conn = nothing
query.movenext
loop
%>
I am getting this error;
Microsoft JET Database Engine error '80040e14'
Syntax error in FROM clause.
/guestbook/guest.asp, line 11
can anyone help me?
View Replies
View Related
I keep getting an error when I try to run this update statment: [CODE]
INSERT INTO MYPosts ( IEname, country, server_name, LANIPAddy, license_ver, wrkstn1, wrkstn2, wrkstn3, wrkstn4, wrkstn5, notes, status, rdse, esc, eso, parent, , timezone, ) VALUES ( '" & lcIEname & "', '" & lcCountry & "', '" & lcServerName & "', '" & lcLicenseVer & "', '" & lcwrkstn1 & "', '" & lcwrkstn2 & "', '" & lcwrkstn3 & "', '" & lcwrkstn4 & "', '" & lcwrkstn5 & "', '" & lcNotes & "', " & lcStatus & ", " & lnRDSE & ", " & lcESC & ", " & lcESO & ", " & lcParent & ", " & lcTimeZone & ")"
I get the following error:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression
View Replies
View Related
I am testing a new website I built on the actual server. My section for uploading documents seems to be giving me problems. Can someone help me please? This is the error I am getting:
Microsoft JET Database Engine error '80004005'
'c:logindatairb.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
/login/insert.asp, line 28
I had this before: .....
View Replies
View Related
I have a query. When I write out the sql and run it directly in the access db. it works. When running it using ado it doesn't work. I know I have run into this before but don't remember what the solution was.
Works in access but when running it using connection.execute sql
I get the following error:
Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
admin.asp, line 345
View Replies
View Related
I've had some problems with an ASP site I've developed. Everything is pretty simple/basic, however, the box it is hosted on is very "neglected" to say the least (old NT 4.0 box, zero services, etc).
Anyway, I have these pages that worked fine until today. The pages are fed from an Access 2000 database. The system administrator's been switching all the DNS records for various boxes lately and was wondering if this could be the culprit giving me this error.
I know this error is often associated with I_USR account privileges, could they have been re-set during this process thus giving me the error? Or could it be something else?
View Replies
View Related
I notice that when you have the defualt setup of 404 error
pages the IIS 5.0 log tracks the page the user was trying
to get to and the page they where at when they tryed to
get to the now missing page. I recently wrote my own 404
error page to make it match my site but when I set IIS to
use my custom page it no longer traks the page that the
user was trying to get.
I was told I needed to add some
code to my page to fix this, but I don't know what code to
add. Can someone tell me? (I am useing ASP on the custom
404 error page) I am returning a 404 error response,
everything works fine it is just that IIS does not log
what page the user was trying to get to.
View Replies
View Related
I created my own custom 404 handler and it works, so when I put in
http://www.domain.com/badxxx.html
it produces the correct 404 error and you see
http://www.domain.com/badxxx.html in the url still which is fine.
But when I put in
http://www.domain.com/asdf
it redirects to
http://www.domain.com/index.html
it gives a 302 (moved temporarily) as well as the 404 error.
Why does it do this for not .html files? I dont redirect it at all, and am
using
thestring = Request.ServerVariables("QUERY_STRING") to get the url
but thestring sometimes does not display the asdf depending what I do after
this command, very odd.
does anybody have anyideas as to how to preserve this
http://www.domain.com/asdf in the url and avoid the 302?
View Replies
View Related
I decide to put a custom Hit Counter on my page (below). Then I won't be
reliant on the standard FrontPage one which uses webbots.
It is called by:
<b>Hit Counter: </b><!--#include file="_fpclass/hit_count.inc"-->
The code it includes is below.
OK, it works - sort of.
If I go to Guestbook and then return via the Home button, the counter
increases by 3, not 1.
I can't see why this is happenning.
After returning, a refresh increases it by 2, then another refresh increases
it by 1 ??
I know that many say "Don't use them - it is a sign of an amateur", but I
would at least like to get it working even if I later decide not to use it.
I have thought to make it a conditional include, i.e. if document.referrer
is blank. Is that possible? Code:
View Replies
View Related
i have a table that users are inserting custom tages ,it looks like :
user_id type value
1 99 television
2 98 beach
3 99 coldplay
etc.
now i have to make a search which will show all the users that typed the same value from the same type .i dont want the query to be a textual query (slow ...)what is the right way to do it ?how can i make a query that JOINs to tables from 2 different databases?
View Replies
View Related
how to go about setting up and using custom sessions for user authentication throughout an application?
View Replies
View Related
I'm developing an application that uses a custom 404 page to deliver all of my site's content. However, doing things this way renders IIS's regular log files pretty much useless.
Are there any established "best practices" for creating your own logging system? I know that others use this technique and I'm hoping someone has some ideas they can pass along. For example, do you log every single page request or do you just log totals per day, week, or month? How do you deal with the increasing volumes of data? Do you collect referrer data, etc.?
View Replies
View Related
I have code for remove button.How to make it a common control so that it will be handy to use.
View Replies
View Related
I asked my hosting service to setup a custom 404 page for me. They did, but when purposely calling a non-existing page with XMLHTTP, the new 404 page returns a 200 / OK status.
They seem to be taking their time trying to fix this, so I wonder if a custom 404 page that truly returns 404 status is a hard thing to set up for individual domains hosted on IIS. I hope my question makes sense to the readers.
View Replies
View Related
im interested in replicating how moonpig.com 's card editor works. in particular how you can display a custom server side font in a wysiwyg editor. i know moonpig uses .net but can this be accomplished using plain ol' asp ?
View Replies
View Related
I've created a custom 404 page that performs redirects based on the incoming
URL cross referenced against a database table.
The problem I have is the way IIS sends on the "not found" information.
Example...
http://www.mysite.com/place/missingpage.asp
is sent on to my custom 404 page by IIS via the Querystring as:
404;http://www.mysite.com/place/missingpage.asp
Which is fine,until I add a Quesrystring to the original URL:
http://www.mysite.com/place/missing...var=10&qwert=11
still comes through as
404;http://www.mysite.com/place/missingpage.asp
without the extra Querystring data from the original URL.
Having researched this online it seems many people have this problem and
looks like IIS 6 solves it. However I've also read of people with IIS 6
having the same issue, and of people with IIS 5 that don't have the problem.
(for exmaple: http://www.webmasterworld.com/forum47/1829.htm)
What I'd like to know is if there is definately no way of achieving this
behaviour on IIS 5 without the use of any extra isapi filters. Perhaps a
server configuration option or something...
View Replies
View Related
I would like to generate a custom date format for my ASP output ... i.e.: "5 Apr 06" instead of the "05 April 2006" that the British English 2057 LCID automatically gives me. In other words, I would like a 3 digit month and two digit year.
The code on my page reads as follows now ...
<%= DoDateTime((Recordset1.Fields.Item("StartDate").Value), 1, 2057) %>
View Replies
View Related
I am trying to do the similar to mod rewrite and use the custom 404 rewrite
page to handle the table look up, so www.myweb.com/irish-tapestry-333.html
will redirect to
www.myweb.com?id=333 for the detail pages.
Will google see this forwarding in the 404 redirect page and ignore the
links?Also, how can I make the URL of www.myweb.com/irish-tapestry-333.html
appear in the users url window instead of the www.myweb.com?id=333
View Replies
View Related
We have a requirement where we have to develop a custom Login Page which
will accept user's NT credentials ( Username , password, domain name).
This then needs to be passed to a website which uses Windows Authentication
my question is how do we pass these credentials to IIS in classic ASP?
View Replies
View Related