[Zope] ZOPE ODBC on Linux

[Hannu Krosing]

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