Methods to connect Linux Zope to ODBC database
Hello, I'm looking for a way to enable our (Debian) Linux-based Zope installation to connect for some very simple (read-only) interaction with a FileMaker Pro database that is available via ODBC. I'm wondering what others have used to do something like this. I realize that there are commercial 'bridge' products out there that will make the connection, but as far as I can see, there isnt an ODBC DA for Linux. Is there any workaround? Or does anyone have any suggestions, or experience with any method that they would be willing to share? Thanks. Chris Beaumont cbeaumon@msri.org
What I did in a similar situation was to install a "slave" Zope instance on the PC with the database (or on any PC machine on the same network) and access the database thru Windows ODBC drivers. Then the main Zope server uses RPC (Client.py, XML-RPC, ...) to get the data from the "slave" server. Not elegant, but it works. -- Loren
-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Chris Beaumont Sent: Wednesday, March 07, 2001 13:53 To: zope@zope.org Subject: [Zope] Methods to connect Linux Zope to ODBC database
Hello,
I'm looking for a way to enable our (Debian) Linux-based Zope installation to connect for some very simple (read-only) interaction with a FileMaker Pro database that is available via ODBC.
I'm wondering what others have used to do something like this. I realize that there are commercial 'bridge' products out there that will make the connection, but as far as I can see, there isnt an ODBC DA for Linux. Is there any workaround? Or does anyone have any suggestions, or experience with any method that they would be willing to share?
Thanks. Chris Beaumont cbeaumon@msri.org
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
participants (2)
-
Chris Beaumont -
Loren Stafford