 Print
 Add To Favorites
 Email To Friend
 Rate This Article
|
SQL Injection in Classic ASP and Possible Solutions
|
by Ehsanul Haque
Feedback
|
Average Rating: 
Views (Total / Last 10 Days):
18405/
362
|
|
|
|
| Avoid disclosing database error information |
To avoid disclosing database error information use
"try…catch" block where possible and provide a user friendly error
message rather than showing system information. Also by configuring IIS, we can
set a general error page. This way no one will get the actual database
information. The way of creating custom error page for ASP application can be
found here. In the error
page, we can implement an automatic error reporting system which will trigger
an email to the programmer with a detailed error report while the error will
occur. A sample can be found in the source code.
|
|
|
|
|
Article Feedback
User Comments
Title:
Replace wrong words
Name:
Eric Coumans
Date:
12/21/2009 10:37:23 AM
Comment:
Hi there,
small question: is it also possible instead of going to the error page, replace the value in the scanned form input?
so when somebody fills in "copenhagen" the function (mentioned above) will change ("open") this into: "c*hagen"...
thanks for the help!
|
Title:
RE: Function always return true
Name:
Ehsanul Haque
Date:
12/9/2009 5:01:13 AM
Comment:
Hello Mr. Javed,
I don't think the function is always returning true. After configuring the sample, open the test.asp and type username "cursor p1" and it will be blocked as the "cursor" is the blacklisted keyword. Similarly, if you write "abc" it will not block as it is not in the blacklist. Also see the relavant code below:
For Each s in BlackList
If(IsExceptionList(s,varType)=False) then
If ( InStr (lstr, s) <> 0 ) Then
CheckStringForSQL = true
Exit Function
End If
End If
Next
Where "lstr" is the string to check and "s" is the blacklisted keyword.
However, please check that the sample is configured correctly. Please let me know if I can help you anyway.
Thanks,
Ehsan
|
Title:
Function always return true
Name:
Javed Iqbal
Date:
12/9/2009 2:01:23 AM
Comment:
\
|
Title:
RE: 谢谢。
Name:
Ehsanul Haque
Date:
12/5/2009 6:40:15 AM
Comment:
Hi,
I don't know Chinese but I think you are looking for code sample. If it is true then please see the entire article here http://aspalliance.com/1703_SQL_Injection_in_Classic_ASP_and_Possible_Solutions.all
Also you can get the sample project by clicking on the Downloads link at the top or browse here http://aspalliance.com/1703_SQL_Injection_in_Classic_ASP_and_Possible_Solutions.all#Page6
Thanks,
Ehsan
|
Title:
Thank you
Name:
Stefan
Date:
11/24/2009 11:22:30 AM
Comment:
Thank you very much. I had some SQL injection problems and I implemented this, tested and it seems to hold up thus far.
Now I have to teach myself stored procedures along with some .net stuff. Thanks again.
|
Title:
:)
Name:
RJ
Date:
1/13/2009 2:04:18 AM
Comment:
good article. it really helps
|
|
|
|
|
|
