[Zope] ODBC Connection
Emmon Simbo
esimbo@openlinksw.co.uk
Tue, 12 Dec 2000 17:19:56 -0000
This is a multi-part message in MIME format.
------=_NextPart_000_0030_01C0645F.C0548850
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
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
------=_NextPart_000_0030_01C0645F.C0548850
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=20
class=3D781145716-12122000>Hi</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D781145716-12122000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D781145716-12122000>Thx=20
for the quick reply. </SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D781145716-12122000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D781145716-12122000>I</SPAN></FONT><FONT color=3D#0000ff =
face=3DArial=20
size=3D2><SPAN class=3D781145716-12122000> already have several =
Datasources in my=20
ODBC control Panel, is there something that I need to do to ensure that =
it picks=20
up a Datasource from this list. All I have done install both Zope and =
the=20
ZODBCDA module, go to the management screen and tried adding a new =
Z mxODBC=20
connection. Is there something I'm missing here</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D781145716-12122000>Thanks</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D781145716-12122000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D781145716-12122000>Emmon</SPAN></FONT></DIV>
<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 13:15<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=3D609190813-12122000>Hi=20
<FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D500531712-12122000>Emmon</SPAN></FONT></SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D609190813-12122000>I=20
don't well understand the exact moment the error=20
occurs:</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D609190813-12122000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D609190813-12122000>If you=20
correctly have the ZODBCDA entry in the product list, you =
should have=20
a new entry in the available objects list.</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D609190813-12122000>Now=20
you have to create a new datasource with the win32 ODBC manager (in =
control=20
panel).</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D609190813-12122000>then go to a folder and add a new ZODBC =
Database=20
connection and chose the created ODBC Datasorce</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D609190813-12122000>for me=20
this work well ... </SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D609190813-12122000>Let me=20
know</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D609190813-12122000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D609190813-12122000>Paolo=20
Quaglia</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 1:19 PM<BR><B>To:</B> Paolo Quaglia;=20
zope@zope.org<BR><B>Subject:</B> RE: [Zope] ODBC=20
Connection<BR><BR></DIV></FONT>
<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.=20
Moving 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:=20
NameError</STRONG><BR><STRONG>Error Value:=20
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>=20
12 December 2000 11:12<BR><B>To:</B> zope@zope.org<BR><B>Subject:</B> =
RE:=20
[Zope] ODBC Connection<BR><BR></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D842090811-12122000>Try=20
to 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=20
class=3D842090811-12122000>Paolo 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 =
<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=20
wondered if there was a How-To that I can use to show me how to use =
Zope=20
with ODBC. I have downloaded the ZmxODBCDA module but when I select =
this=20
from the Products menu, it shows up as ZmxODBCDA(Broken product =
ZmxODBCA). If I click on 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=20
Simbo<BR>Consultant<BR>OpenLink Software<BR>Tel: +44 (0) 20 8681=20
7701<BR>Web: </FONT><A href=3D"http://www.openlinksw.com/"><FONT=20
face=3D"Century Gothic" =
size=3D2>http://www.openlinksw.com</FONT></A><BR><FONT=20
face=3D"Century Gothic" size=3D2>XML & E-Business Infrastructure =
Technology=20
Provider <BR></FONT></DIV>
<DIV> </DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0030_01C0645F.C0548850--