odbc da for zope on linux
Date: Thu, 06 Mar 2003 13:21:06 +0000 From: andy <andy@bigorangelovebus.net> Subject: odbc da for zope on linux
Hi,
Am I right in syaing that there is no such DA for zope running on linux? I can find the DA for the win platform, but can't find an equivalent for Linux..... I need to access information in an Access copied on a Linux server (where zope will also be running). All the clients connected to the server are Win98, so can't run Zope as a service anywhere else. Not sure if there's a problem with accessing data from this db if it's on the Linux server - if there is then I'll just point the DB request to one of the network machines. But first I need to get an adapter that works, and so far I can't see one.
Your Access mdb file is on your Linux box? I don't think you can open it there. You'll need to put it on a Windows box, then talk to it via ODBC over the network. Marc-Andre Lemburg's new and excellent mxODBC Zope Adapter will do the job. It's a bargain at $95 per Zope server. I'm using it on Windows, but have tested his mxODBC module on Linux, and it works. mxODBC enables Python to talk to the ODBC driver manager on your Linux box. There are a couple of free ODBC driver mgrs available for Linux. Then for getting your Linux box to talk to the Access box, there are one or two free projects as well as commercial products (http://easysoft.com/). If you don't need to keep the db in Access for other reasons, now would be an excellent time to take a good look at PostgreSql. You can probably get more answers on the Zope-db list. Wade Leftwich Ithaca, NY
Wade Leftwich wrote at 2003-3-6 12:40 -0500:
... Your Access mdb file is on your Linux box? I don't think you can open it there. You'll need to put it on a Windows box, then talk to it via ODBC over the network.
I think I read about reading "mdb" files in "comp.lang.python.*". Please, search via Google. I may be wrong, though, and read about them elsewhere (I am not interested in Access at all). Dieter
Thanks Wade & all, It looks like the easiest way forward is to convert all the databases to mysql, front-end them for the users with Access, and use the mysqlda for the zope stuff. Only problem I'm having is getting the MySQL-python-0.9.0 setup.py file to work. It claims there's no such file as distutils.core, even though I can find that file myself. Any ideas where I'm going wrong? I've got all the databases ready to roll, and just need the DA to work. According to my system, the core.py file is in /usr/lib/python2.1/distutils/, and the setup.py file in the MySQL-python-0.9.0 directory reads: #!/usr/bin/env python import os, sys from distutils.core import setup from distutils.extension import Extension If I try to build or install this file, then I get an error saying: ImportError: No module named distutils.core Should I be changing some of the setup.py file? I can't see where the problem lies... Thanks in advance for any help. Andy Wade Leftwich wrote:
Your Access mdb file is on your Linux box? I don't think you can open it there. You'll need to put it on a Windows box, then talk to it via ODBC over the network.
Marc-Andre Lemburg's new and excellent mxODBC Zope Adapter will do the job. It's a bargain at $95 per Zope server. I'm using it on Windows, but have tested his mxODBC module on Linux, and it works.
mxODBC enables Python to talk to the ODBC driver manager on your Linux box. There are a couple of free ODBC driver mgrs available for Linux. Then for getting your Linux box to talk to the Access box, there are one or two free projects as well as commercial products (http://easysoft.com/).
If you don't need to keep the db in Access for other reasons, now would be an excellent time to take a good look at PostgreSql.
You can probably get more answers on the Zope-db list.
Wade Leftwich Ithaca, NY
my 2cents... we use access to front end mysql (hopefully not for long). The character sets in access wreak havoc for us in our database. Between special characters, and M$ wanting to control spelling, etc. , it's a (boardline) nightmare. If you HAVE to front end mysql w/ access, I'd put all input / edit fields in a courier font. This seems to help view all of the garbage that can be placed in the database. Bobb ----- Original Message ----- From: "andy" <andy@bigorangelovebus.net> To: "Wade Leftwich" <wade@lightlink.com> Cc: <Zope@zope.org> Sent: Thursday, March 13, 2003 5:43 AM Subject: Re: [Zope] odbc da for zope on linux
Thanks Wade & all,
It looks like the easiest way forward is to convert all the databases to mysql, front-end them for the users with Access, and use the mysqlda for the zope stuff. Only problem I'm having is getting the MySQL-python-0.9.0 setup.py file to work. It claims there's no such file as distutils.core, even though I can find that file myself.
Any ideas where I'm going wrong? I've got all the databases ready to roll, and just need the DA to work. According to my system, the core.py file is in /usr/lib/python2.1/distutils/, and the setup.py file in the MySQL-python-0.9.0 directory reads:
#!/usr/bin/env python
import os, sys from distutils.core import setup from distutils.extension import Extension
If I try to build or install this file, then I get an error saying:
ImportError: No module named distutils.core
Should I be changing some of the setup.py file? I can't see where the problem lies...
Thanks in advance for any help.
Andy
Wade Leftwich wrote:
Your Access mdb file is on your Linux box? I don't think you can open it there. You'll need to put it on a Windows box, then talk to it via ODBC over the network.
Marc-Andre Lemburg's new and excellent mxODBC Zope Adapter will do the
job.
It's a bargain at $95 per Zope server. I'm using it on Windows, but have tested his mxODBC module on Linux, and it works.
mxODBC enables Python to talk to the ODBC driver manager on your Linux box. There are a couple of free ODBC driver mgrs available for Linux. Then for getting your Linux box to talk to the Access box, there are one or two free projects as well as commercial products (http://easysoft.com/).
If you don't need to keep the db in Access for other reasons, now would be an excellent time to take a good look at PostgreSql.
You can probably get more answers on the Zope-db list.
Wade Leftwich Ithaca, NY
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
participants (4)
-
andy -
Bobb -
Dieter Maurer -
Wade Leftwich