Microsoft Access Database connecting from Python through ODBC

[Jeremie Legault]

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.

Thanks in advance,

Jeremie

jerlegault at hotmail.com
jivesojer at hotmail.com