[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)