[Zope] ODBC Connection
Emmon Simbo
esimbo@openlinksw.co.uk
Tue, 12 Dec 2000 12:19:04 -0000
This is a multi-part message in MIME format.
------=_NextPart_000_0015_01C06435.B7EF2000
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
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
------=_NextPart_000_0015_01C06435.B7EF2000
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D500531712-12122000>Hi=20
Paolo</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D500531712-12122000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D500531712-12122000>I=20
already have that. The problem was that it wasn't in the lib/python =
path. Moving=20
it there fixed the problem. Now I get an error</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D500531712-12122000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D500531712-12122000><STRONG>Error Type: =
NameError</STRONG><BR><STRONG>Error=20
Value: SQLDataSources</STRONG><BR></SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D500531712-12122000>when I try to add a new=20
datasource.</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D500531712-12122000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D500531712-12122000>Emmon</DIV></SPAN></FONT>
<DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> zope-admin@zope.org=20
[mailto:zope-admin@zope.org]<B>On Behalf Of </B>Paolo =
Quaglia<BR><B>Sent:</B> 12=20
December 2000 11:12<BR><B>To:</B> zope@zope.org<BR><B>Subject:</B> RE: =
[Zope]=20
ODBC Connection<BR><BR></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D842090811-12122000>Try to=20
use the ZODBCDA </SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D842090811-12122000><A=20
href=3D"http://www.zope.org/Products/DA/ZODBCDA">http://www.zope.org/Prod=
ucts/DA/ZODBCDA</A></SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D842090811-12122000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D842090811-12122000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D842090811-12122000>It=20
works very well!</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D842090811-12122000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D842090811-12122000>Paolo=20
Quaglia</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D842090811-12122000></SPAN></FONT> </DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #0000ff 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: =
0px; PADDING-LEFT: 5px">
<DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> =
zope-admin@zope.org=20
[mailto:zope-admin@zope.org]<B>On Behalf Of </B>Emmon =
Simbo<BR><B>Sent:</B>=20
Tuesday, December 12, 2000 11:26 AM<BR><B>To:</B>=20
zope@zope.org<BR><B>Subject:</B> [Zope] ODBC =
Connection<BR><BR></DIV></FONT>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D512571710-12122000>Hi=20
<BR></SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D512571710-12122000>I =
have a few=20
customers who are using Zope and have shown an interest in using=20
</SPAN></FONT><FONT face=3DArial size=3D2><SPAN =
class=3D512571710-12122000>the=20
OpenLink ODBC Drivers. Unfortunately, I am not familiar with Zope and =
wondered=20
if there was a How-To that I can use to show me how to use Zope with =
ODBC. I=20
have downloaded the ZmxODBCDA module but when I select this from the =
Products=20
menu, it shows up as ZmxODBCDA(Broken product ZmxODBCA). If I =
click on=20
the link, I get</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D512571710-12122000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D512571710-12122000><BR> File=20
"D:\APPS\ZopeWeb\lib\python\OFS\Application.py", line 397, in=20
import_products<BR> product=3D__import__(pname, =
global_dict,=20
global_dict, silly)<BR> File=20
"D:\APPS\ZopeWeb\lib\python\Products\ZmxODBCDA\__init__.py", line 91, =
in=20
?<BR> import DA<BR> File=20
"D:\APPS\ZopeWeb\lib\python\Products\ZmxODBCDA\DA.py", line 92, in=20
?<BR> from db import DB, =
manage_ODBCDataSources<BR> =20
File "D:\PROGRA~1\Zope22\lib\python\Products\ZmxODBCDA\db.py", line =
87, in=20
?<BR>ImportError: No module named mx.ODBC<BR><BR></SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D512571710-12122000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D512571710-12122000>Any =
ideas what's=20
wrong here and secondly how I can go about making an ODBC=20
connection.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D512571710-12122000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D512571710-12122000>Thanks for you=20
help in advance</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D512571710-12122000></SPAN></FONT> </DIV>
<DIV><FONT face=3D"Century Gothic" size=3D2>Best Regards,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"Century Gothic" size=3D2>Emmon =
Simbo<BR>Consultant<BR>OpenLink=20
Software<BR>Tel: +44 (0) 20 8681 7701<BR>Web: </FONT><A=20
href=3D"http://www.openlinksw.com/"><FONT face=3D"Century Gothic"=20
size=3D2>http://www.openlinksw.com</FONT></A><BR><FONT face=3D"Century =
Gothic"=20
size=3D2>XML & E-Business Infrastructure Technology Provider=20
<BR></FONT></DIV>
<DIV> </DIV></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0015_01C06435.B7EF2000--