ODBC errors not showing in IIS7

Posted on 2009-04-26
Last Modified: 2012-06-27
hi all,
i've recently set up a server running IIS7... all error messages are set to send to browser and VBScript errors are displayed the same as in iis6 etc...
my problem is that whenever there is a error which is database related (creating a recordset or displaying field contents) then no error is given, the page simply stops loading...
this means that if the problem is in creating a recordset then you just get a blank page... if the problem is in the midst of html markup at least then a 'view source' shows you where the error occured...

i'm currently using "on error resume" to get past the error and

If Err.Number <> 0 Then  
response.write Err.Number &""& Err.Description
End if

to find the error, but when you have several recordets or lots of code it still makes debugging a very slow process...

so, does anyone know how to get back ODBC debugging?

btw, i'm using classic asp...
Question by:dog_star
    LVL 13

    Accepted Solution

    1) Turn Windows futures on or off under Control Panel\Programs\

    Under Internet Information Services > Web Management Tools
      Switch on IIS Management Console/Management Scripts and Tools/Management Service

    Under Internet Information Services > World Wide Web Services > Application Developement Features
      Switch on all features

    Under Internet Information Services > World Wide Web Services > Common Http features
      Switch on Default Document and Static content (can now see image in iistart.htm welcome page)

    Under Internet Information Services > World Wide Web Services > Security
      Switch on Basic Authentication, Request Filtering, and Windows Auhentication

    2) Run Internet Information Services (IIS) Manager under Control Panel\System and Maintenance\Administrative Tools
    Double click on the ASP icon

    Under Behaviour
      Set Enable Parent Paths to True (so as not to change existing ASP code)

    Under Debugging Properties
      Set Errors To Browser to True

    Author Comment

    sorry for the delay in replying...

    couldn't find some of the options you mention in 1)

    2) already set "errors to browser" but it still doesn't display them... the only way i've found is to use ASP script to display the error, which isn't very efficient...

    Author Comment

    as a follow up i eventually found this fix :

    run the following at the CMD prompt :

    %windir%\system32\inetsrv\appcmd set config -section:asp -scriptErrorSentToBrowser:true

    this seems to do the trick...

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
    Running classic asp applications under Windows Server 2008 R2 (x64) and IIS 7 is not as easy as one may think. It took me a while to figure it out while getting error 8002801d a few times. After you install the OS you will need to install the fol…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now