Hi
Emmon
I
don't well understand the exact moment the error
occurs:
If you
correctly have the ZODBCDA entry in the product list, you should have
a new entry in the available objects list.
Now
you have to create a new datasource with the win32 ODBC manager (in control
panel).
then go to a folder and add a new ZODBC Database
connection and chose the created ODBC Datasorce
for me
this work well ...
Let me
know
Paolo
Quaglia
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Emmon Simbo
Sent: Tuesday, December 12, 2000 1:19 PM
To: Paolo Quaglia; [EMAIL PROTECTED]
Subject: RE: [Zope] ODBC ConnectionHi PaoloI already have that. The problem was that it wasn't in the lib/python path. Moving it there fixed the problem. Now I get an errorError Type: NameError
Error Value: SQLDataSourceswhen I try to add a new datasource.Emmon-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paolo Quaglia
Sent: 12 December 2000 11:12
To: [EMAIL PROTECTED]
Subject: RE: [Zope] ODBC ConnectionTry to use the ZODBCDAIt works very well!Paolo Quaglia-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Emmon Simbo
Sent: Tuesday, December 12, 2000 11:26 AM
To: [EMAIL PROTECTED]
Subject: [Zope] ODBC ConnectionHiI 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.ODBCAny ideas what's wrong here and secondly how I can go about making an ODBC connection.Thanks for you help in advanceBest Regards,Emmon Simbo
Consultant
OpenLink Software
Tel: +44 (0) 20 8681 7701
Web: http://www.openlinksw.com
XML & E-Business Infrastructure Technology Provider