Microsoft Access Database connecting from Python through ODBC

Sat Dec 7 16:56:36 EST 2002

On Thu, 5 Dec 2002 15:47:58 -0500, "Jeremie Legault"
<jlegault at impathnetworks.com> wrote:

>I wonder if anyone knows how to format the login string to connect to a
>Microsoft Access Database through ODBC. If I open a shell and test my code
>it connects without needing a user ID and password. However if I connect
>through a CGI script (python is invoked by the CGI request) I can not
>connect to the database. I tried adding the
>'DSN=OwnDatabase;UID=Mikkon;PWD=abcde' but this returns errors. I believe it
>works when I invoke the program because I am logged in with an account that
>has valid permission to interact with the database.

The default login, if you have not modified system.mdw, is "DSN='DSN
name';UID=Admin;PWD=''". Have you tried that already?