[Zope] ODBC Connection
Hi I have a few customers who are using Zope and have shown an interest inusing 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(Brokenproduct 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 SimboConsultantOpenLink SoftwareTel: +44 (0) 20 8681 7701Web: http://www.openlinksw.comXML E-Business Infrastructure Technology Provider BEGIN:VCARD VERSION:2.1 N:Simbo;Emmon FN:Emmon Simbo ORG:OpenLink Software TITLE:Professional Services Consultant TEL;WORK;VOICE:0208 681 7701 TEL;WORK;VOICE:0468 573 573 TEL;WORK;FAX:02086817702 ADR;WORK;ENCODING=QUOTED-PRINTABLE:;;Amy Johnson House=0D=0A22-26 Dingwall Rd;Croydon;Surrey;CR0 9XF;United Kin= gdom LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Amy Johnson House=0D=0A22-26 Dingwall Rd=0D=0ACroydon, Surrey CR0 9XF=0D=0AU= nited Kingdom ADR;HOME:;;United Kingdom LABEL;HOME:United Kingdom URL:http://www.openlink.co.uk URL:http://www.openlinksw.co.uk EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20001106T182603Z END:VCARD
RE: [Zope] ODBC Connection
Thanks Philipp. That solved the problem. Is there actually a How-To on what to do as when I go to add a new Datasource, I get the error Error Type: NameError Error Value: SQLDataSources Thanks again for you answer Emmon -Original Message- From: Philipp Auersperg [mailto:[EMAIL PROTECTED]] Sent: 12 December 2000 11:51 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [Zope] ODBC Connection 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 ___ Zope maillist - [EMAIL PROTECTED] 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 )
RE: [Zope] ODBC Connection
Hi Paolo I 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 error Error Type: NameErrorError Value: SQLDataSources whenI try to add a new datasource. Emmon -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paolo QuagliaSent: 12 December 2000 11:12To: [EMAIL PROTECTED]Subject: RE: [Zope] ODBC Connection Try to use the ZODBCDA http://www.zope.org/Products/DA/ZODBCDA It works very well! Paolo Quaglia -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Emmon SimboSent: Tuesday, December 12, 2000 11:26 AMTo: [EMAIL PROTECTED]Subject: [Zope] ODBC Connection Hi I have a few customers who are using Zope and have shown an interest inusing 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(Brokenproduct 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 SimboConsultantOpenLink SoftwareTel: +44 (0) 20 8681 7701Web: http://www.openlinksw.comXML E-Business Infrastructure Technology Provider
RE: [Zope] ODBC Connection
Hi Thx for the quick reply. I already have several Datasources in my ODBC control Panel, is there something that I need to do to ensure that it picks up a Datasource from this list. All I have done install both Zope and the ZODBCDA module,go to the management screen and tried adding a new Z mxODBC connection. Is there something I'm missing here Thanks Emmon -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paolo QuagliaSent: 12 December 2000 13:15To: [EMAIL PROTECTED]Subject: RE: [Zope] ODBC Connection Hi Emmon I don't well understandthe exact moment the error occurs: If you correctly havetheZODBCDA 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). thengo 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 SimboSent: Tuesday, December 12, 2000 1:19 PMTo: Paolo Quaglia; [EMAIL PROTECTED]Subject: RE: [Zope] ODBC Connection Hi Paolo I 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 error Error Type: NameErrorError Value: SQLDataSources whenI try to add a new datasource. Emmon -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paolo QuagliaSent: 12 December 2000 11:12To: [EMAIL PROTECTED]Subject: RE: [Zope] ODBC Connection Try to use the ZODBCDA http://www.zope.org/Products/DA/ZODBCDA It works very well! Paolo Quaglia -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Emmon SimboSent: Tuesday, December 12, 2000 11:26 AMTo: [EMAIL PROTECTED]Subject: [Zope] ODBC Connection Hi I have a few customers who are using Zope and have shown an interest inusing 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(Brokenproduct 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 SimboConsultantOpenLink SoftwareTel: +44 (0) 20 8681 7701Web: http://www.openlinksw.comXML E-Business Infrastructure Technology Provider
