Microsoft Access Database connecting from Python through ODBC

[Jeremie]

I have tried something similiar but it didn't work.Henrik mentioned that I
had to show add a line that pointed to the SYSTEM.MDW file (Microsoft Access
Security File). But I think the ODBC driver should handle that I mean that
is the whole purpose I thought. I am going to try the way you formatted it.
Thanks for the suggestion.
Jeremie
"Alejandro Lopez-Valencia" <dradul at mailandnews.com> wrote in message
news:astqqr$us987$1 at ID-99513.news.dfncis.de...
> 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?
>
>