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
Try to use the ZODBCDA http://www.zope.org/Products/DA/ZODBCDA It works very well! Paolo Quaglia -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Emmon Simbo Sent: Tuesday, December 12, 2000 11:26 AM To: zope@zope.org Subject: [Zope] ODBC Connection 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
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: NameError Error Value: SQLDataSources when I try to add a new datasource. Emmon -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Paolo Quaglia Sent: 12 December 2000 11:12 To: zope@zope.org 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: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Emmon Simbo Sent: Tuesday, December 12, 2000 11:26 AM To: zope@zope.org Subject: [Zope] ODBC Connection 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
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: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Emmon Simbo Sent: Tuesday, December 12, 2000 1:19 PM To: Paolo Quaglia; zope@zope.org 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: NameError Error Value: SQLDataSources when I try to add a new datasource. Emmon -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Paolo Quaglia Sent: 12 December 2000 11:12 To: zope@zope.org 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: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Emmon Simbo Sent: Tuesday, December 12, 2000 11:26 AM To: zope@zope.org Subject: [Zope] ODBC Connection 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
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: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Paolo Quaglia Sent: 12 December 2000 13:15 To: zope@zope.org Subject: RE: [Zope] ODBC Connection 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: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Emmon Simbo Sent: Tuesday, December 12, 2000 1:19 PM To: Paolo Quaglia; zope@zope.org 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: NameError Error Value: SQLDataSources when I try to add a new datasource. Emmon -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Paolo Quaglia Sent: 12 December 2000 11:12 To: zope@zope.org 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: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Emmon Simbo Sent: Tuesday, December 12, 2000 11:26 AM To: zope@zope.org Subject: [Zope] ODBC Connection 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
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
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:zope@philosoft.at] Sent: 12 December 2000 11:51 To: esimbo@openlinksw.co.uk; zope@zope.org 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
Hi Phil, I have done what you have suggested and Zope start without errors. I can build a new ZmxODBC connection to a SQL server 7.0, and Zope doesn't return errors. Now I tried to browser the DB (that already exists) and I got this Error: Error Type: InterfaceError Error Value: SQL type (code -9) not implemented I tried to make a simple select in a already existent Table ex: select * from T_TIPO but the same error occurs I created some new table with the test query utils in Zope and no error was presented. I can make select in those new tables. How is the Problem?? With The ZODBCDA I can browse the DB and all works? Any Idea? Any Suggestion? Thanks Very Much Paolo Quaglia
-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Philipp Auersperg Sent: Tuesday, December 12, 2000 12:51 PM To: esimbo@openlinksw.co.uk; zope@zope.org 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
participants (3)
-
Emmon Simbo -
Paolo Quaglia -
Philipp Auersperg