Installing ODBC on PythonWin
gmcm at hypernet.com
Sat Jun 19 00:48:53 CEST 1999
Andrew Clover has Access problems:
> I've got an Access database accessed by Python scripts under CGI.
> sometimes, calls to odbc.odbc(dsn) hang up and never return.
> (Eventually the web server times out and kills the process.) This
> seems to happen randomly, but increasingly. Does anyone have any
> idea why? A fault with the odbc module, or Access, or what?
Repeat after me: "Access is NOT a server, Access is NOT a server".
It is a file access method. If you access it through Jet (ie, DAO or
one of those) it is sort-of safe for multiuser usage. If accessed
through ODBC it is most definitely absolutely NOT safe. It's not even
safe for mutiple connections from one process.
Access is dandy on the desktop as an overgrown spreadsheet. It is the
LAST thing you should use for CGI.
More information about the Python-list