[Zope] ODBC Connection

Paolo Quaglia paolo@sitek.it
Tue, 12 Dec 2000 12:12:03 +0100


This is a multi-part message in MIME format.

------=_NextPart_000_001C_01C06434.BCAAEFD0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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_001C_01C06434.BCAAEFD0
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.2314.1000" name=3DGENERATOR></HEAD>
<BODY>
<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>&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 =
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>&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=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&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 =
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&nbsp;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>&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 =
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 &amp; E-Business Infrastructure Technology Provider=20
  <BR></FONT></DIV>
  <DIV>&nbsp;</DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_001C_01C06434.BCAAEFD0--