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 Quaglia
Sent: 12 December 2000 13:15
To: [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 Simbo
Sent: Tuesday, December 12, 2000 1:19 PM
To: 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: NameError
Error Value: SQLDataSources
when 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 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 Simbo
Sent: Tuesday, December 12, 2000 11:26 AM
To: [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 Simbo
Consultant
OpenLink Software
Tel: +44 (0) 20 8681 7701
Web:
http://www.openlinksw.com
XML & E-Business Infrastructure Technology Provider
 

Reply via email to