Randall Marbach wrote:
Is it possible for a Zope 1.9 installation running on a linux platform (redhat 5.2) to access a MS ACCESS database located on a different NT server via the ODBC support built into Zope?
As Access is not a client-server database, you are unable to use it even from another Windows (NT or 9x) machine. You could make both Access and Zope talk to MS SQL server though.
If not, is there some other way to do this?
Your best bet would be to run a minimal webserver with python ODBC module on the NT box and serve the database pages from there. If required these can be served only to the Zope machine which uses them to construct its pages (you could then just forward your SQL to the NT and get pickled result back to Zope - ODBCGateDA anyone ;). One friend of mine who needs to access XBase files does something similar quite successfully using Apache and pytrhon CGI scripts (NT Apache understands the "#! c:\python\python.exe" line in the beginning of script, and Win32 python together with ODBC module and other goodies is available from www.python.org) ------------------- Hannu