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 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 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 when I 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 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 SimboConsultantOpenLink SoftwareTel: +44 (0) 20 8681 7701Web: http://www.openlinksw.comXML & E-Business Infrastructure Technology Provider
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: [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 when I 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 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 SimboConsultantOpenLink SoftwareTel: +44 (0) 20 8681 7701Web: http://www.openlinksw.comXML & E-Business Infrastructure Technology Provider
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 when I 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 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 SimboConsultantOpenLink SoftwareTel: +44 (0) 20 8681 7701Web: http://www.openlinksw.comXML & E-Business Infrastructure Technology Provider
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
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
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 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 SimboConsultantOpenLink SoftwareTel: +44 (0) 20 8681 7701Web: http://www.openlinksw.comXML & E-Business Infrastructure Technology Provider
RE: [Zope] ODBC connection to Oracle
We have had mixed results depending on the ODBC driver you use to make your DSN. Here is what I found. 1. Microsofts ODBC Driver for ORACLE on NT4.0, NT2000 -CREATE DSN -OK -ZOPE ZODBC -OK -ZSQL METHODS -OK 2. ORACLE ODBC DRIVER on NT 4.0, Especially NT2000 -CREATE DSN -OK -ZOPE ZODBC CONNECTION -OK Visually! On First Query it will break. -ZSQL METHODS -Broken When in doubt use the MICROSOFT DRIVER for ODBC! That is our rule. You will also find that this same problem exists in using ORACLE drivers when viewing databases via ACCESS. It will typically crash Access and potentially more. Theodore E. Patrick Ishophere.com - Indigo Networks -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 01, 2000 12:16 PM To: [EMAIL PROTECTED] Subject: [Zope] ODBC connection to Oracle Hi there, Has anyone tried connecting using ZODBC from a WinNT machine to an Oracle database? The ODBC connection works. But when I create a ZODBC connection from ODBC dsn, it doesn't. I give the connect string as DSN userid password as mentioned under ZODBC add screen... Any help? Thanks Babu http://vsbabu.csoft.net ___ 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 ) ___ 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 )