<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.4417.0">
<TITLE>RE: [python-win32] catching odbc errors in Python/ASP pages</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Geoff Talvola [<A HREF="mailto:gtalvola@nameconnector.com">mailto:gtalvola@nameconnector.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Thursday, April 26, 2001 11:46 AM</FONT>
<BR><FONT SIZE=2>To: Bill Seitz; python-list@python.org</FONT>
<BR><FONT SIZE=2>Subject: Re: [python-win32] catching odbc errors in Python/ASP pages</FONT>
</P>
<P><FONT SIZE=2>At 06:09 PM 4/23/01 -0400, Bill Seitz wrote:</FONT>
<BR><FONT SIZE=2>>>Having an implementation problem, ASP pages failing when rolled out to</FONT>
<BR><FONT SIZE=2>>>production server, when they worked fine on dev machine and on staging</FONT>
<BR><FONT SIZE=2>>>server. Trying to track down problem....</FONT>
</P>
<P><FONT SIZE=2>>I would guess that it's an account permissions problem. I don't know what </FONT>
<BR><FONT SIZE=2>>version of IIS you're using, but on IIS 4.0, you can open up the property </FONT>
<BR><FONT SIZE=2>>pages for the folder containing your ASP pages, go to the "Directory </FONT>
<BR><FONT SIZE=2>>Security" tab of the property page, then in the "Anonymous Access and </FONT>
<BR><FONT SIZE=2>>Authentication Control" section click "Edit", then under "Account used for </FONT>
<BR><FONT SIZE=2>>Anonymous Access" click "Edit". Here you can specify the NT user account </FONT>
<BR><FONT SIZE=2>>that will be used to run these ASP pages when accessed anonymously -- i.e. </FONT>
<BR><FONT SIZE=2>>through the web. You need to specify an account that has the ability to </FONT>
<BR><FONT SIZE=2>>access your database server.</FONT>
</P>
<P><FONT SIZE=2>But</FONT>
<BR><FONT SIZE=2>- I'm not running the pages anonymously, login is being triggered. So the "account used for anonymous access" shouldn't be relevant, right?</FONT></P>
<P><FONT SIZE=2>- my odbc connection call passes the DSN along with a user ID and password (the same ones used on the servers which work)</FONT></P>
<P><FONT SIZE=2>- the error I'm getting is a generic "client unable to establish connection", not a "user id rejected" (or whatever the appropriate message is: I've seen that in other cases).</FONT></P>
<P><FONT SIZE=2>Does that change your opinion?</FONT>
</P>
<P><FONT SIZE=2>(But I'm still trying to dig into this...)</FONT>
</P>
</BODY>
</HTML>