Home Original page

ADO/ODBC call via Python/IIS

David Fuess fuess at att.net
Wed Feb 7 20:56:54 EST 2001 
See my response to dsavitsk for connecting to a database using ADO. As
for DSNless, I take it to mean that no DSN need be created for the
database to be visible. For instance, SQL Server databases that you
connect using the ADODB.Connection mechanism do not have DSN's (either
user or system). If you want to use ODBC mechanisms to connect then
you do have to have a system DSN assigned for it to be visible. This
is what one does to get to an Access database using the Jet engine.

Dave

On Thu, 08 Feb 2001 00:34:37 GMT, Mark Hammond <MarkH at ActiveState.com>
wrote:

>Bill Seitz wrote:
>
>> Well, it's a User DSN. Do you know that ASP expects a system DSN?
>
>ASP does not execute as your user, but as its own system user.  Thus, a user DSN created for your user is simply not visible by ASP.  It must be system DSN, or a user DSN for the ASP specific user
>
>> And, I'm not clear on what a DSN-less connection is. Does this mean
>
>Neither do I - hopefully someone else will ;-)
>
>Mark.
More information about the Python-list mailing list