[Zope] MS Access interfacing

J. Cameron Cooper jccooper@rice.edu
Fri, 20 Jul 2001 10:59:58 -0500


>
>
>There's no problem getting data from an Access database via ODBC as long as
>the ODBC driver and the database are on the **same Windows machine**.  I've
>not been able to make this work when the server+odbc is on a different
>machine from the database.
>...
>Another approach would be to get a python xml-rpc server running on the
>Windows machine.  That would use mxodbc to get data from the database and
>return it to Zope using xml-rpc.  This should be pretty easy to do.
>
There was a discussion on this list not-too-long-ago on this very 
subject, which seems to have resulted in a proxying database connection 
that has been used successfully to do this very thing.

Look at the thread starting at
http://lists.zope.org/pipermail/zope/2001-July/095091.html

The most important one is
http://lists.zope.org/pipermail/zope/2001-July/095159.html

            --jcc
        (not proxying)