[Zope] ODBC Connection

[Philipp Auersperg]

the ZmxODBC DA uses the Zope-independent product mxODBC, that provides a generic 
Python DB API compliant ODBC interface to Python.

ZmxODBC installs mxODBC into lib/python/Shared/mx. The problem is that this path is not in the default PythonPath.

Solution:
move the mx directory from lib/python/Shared into a directory that's member of PythonPath (for example lib/python).

phil
*********** REPLY SEPARATOR ***********

On 12.12.2000 at 10:25 Emmon Simbo wrote:
Hi 

I have a few customers who are using Zope and have shown an interest in using the OpenLink ODBC Drivers. Unfortunately, I am not familiar with Zope and wondered if there was a How-To that I can use to show me how to use Zope with ODBC. I have downloaded the ZmxODBCDA module but when I select this from the Products menu, it shows up as ZmxODBCDA(Broken product ZmxODBCA). If I click on the link, I get
 

  File "D:\APPS\ZopeWeb\lib\python\OFS\Application.py", line 397, in import_products
    product=__import__(pname, global_dict, global_dict, silly)
  File "D:\APPS\ZopeWeb\lib\python\Products\ZmxODBCDA\__init__.py", line 91, in ?
    import DA
  File "D:\APPS\ZopeWeb\lib\python\Products\ZmxODBCDA\DA.py", line 92, in ?
    from db import DB, manage_ODBCDataSources
  File "D:\PROGRA~1\Zope22\lib\python\Products\ZmxODBCDA\db.py", line 87, in ?
ImportError: No module named mx.ODBC


 
Any ideas what's wrong here and secondly how I can go about making an ODBC connection.
 
Thanks for you help in advance
 
Best Regards,

Emmon Simbo
Consultant
OpenLink Software
Tel: +44 (0) 20 8681 7701
Web: http://www.openlinksw.com
XML & E-Business Infrastructure Technology Provider