[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>&nbsp;</DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D781145716-12122000>Thx=20
for the quick reply.&nbsp;</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D781145716-12122000></SPAN></FONT>&nbsp;</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,&nbsp;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>&nbsp;</DIV>
<DIV>&nbsp;</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>&nbsp;</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&nbsp;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>&nbsp;</DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D609190813-12122000>If you=20
correctly have&nbsp;the&nbsp;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&nbsp;go to a folder and add a new ZODBC =
Database=20
connection and chose the created ODBC Datasorce</SPAN></FONT></DIV>
<DIV>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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&nbsp;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>&nbsp;</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>&nbsp;</DIV>
  <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
  class=3D842090811-12122000></SPAN></FONT>&nbsp;</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>&nbsp;</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>&nbsp;</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&nbsp;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&nbsp;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>&nbsp;</DIV>
    <DIV><FONT face=3DArial size=3D2><SPAN =
class=3D512571710-12122000><BR>&nbsp; File=20
    "D:\APPS\ZopeWeb\lib\python\OFS\Application.py", line 397, in=20
    import_products<BR>&nbsp;&nbsp;&nbsp; product=3D__import__(pname, =
global_dict,=20
    global_dict, silly)<BR>&nbsp; File=20
    "D:\APPS\ZopeWeb\lib\python\Products\ZmxODBCDA\__init__.py", line =
91, in=20
    ?<BR>&nbsp;&nbsp;&nbsp; import DA<BR>&nbsp; File=20
    "D:\APPS\ZopeWeb\lib\python\Products\ZmxODBCDA\DA.py", line 92, in=20
    ?<BR>&nbsp;&nbsp;&nbsp; from db import DB, =
manage_ODBCDataSources<BR>&nbsp;=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>&nbsp;</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>&nbsp;</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>&nbsp;</DIV>
    <DIV><FONT face=3D"Century Gothic" size=3D2>Best =
Regards,</FONT></DIV>
    <DIV>&nbsp;</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 &amp; E-Business Infrastructure =
Technology=20
    Provider <BR></FONT></DIV>
    <DIV>&nbsp;</DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0030_01C0645F.C0548850--