[python-win32] catching odbc errors in Python/ASP pages

[Geoff Talvola]

At 06:09 PM 4/23/01 -0400, Bill Seitz wrote:
>Having an implementation problem, ASP pages failing when rolled out to
>production server, when they worked fine on dev machine and on staging
>server. Trying to track down problem....

I would guess that it's an account permissions problem.  I don't know what 
version of IIS you're using, but on IIS 4.0, you can open up the property 
pages for the folder containing your ASP pages, go to the "Directory 
Security" tab of the property page, then in the "Anonymous Access and 
Authentication Control" section click "Edit", then under "Account used for 
Anonymous Access" click "Edit".  Here you can specify the NT user account 
that will be used to run these ASP pages when accessed anonymously -- i.e. 
through the web.  You need to specify an account that has the ability to 
access your database server.

I don't know how to improve your error reporting though.  The whole ASP 
with Python thing is a mysterious black box.  I tried it out and was 
dissatisfied.  Then I switched to using Webware for Python and have found 
it to be better in every respect.  I don't know if that's an option for 
you, but if it is, I highly recommend trying 
it.  http://Webware.sourceforge.net/


--

- Geoff Talvola
   gtalvola at NameConnector.com