[Zope] ODBC Connection

Emmon Simbo esimbo@openlinksw.co.uk
Tue, 12 Dec 2000 10:25:41 -0000


This is a multi-part message in MIME format.

------=_NextPart_000_0006_01C06425.E11214C0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_001_0007_01C06425.E11214C0"


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

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_001_0007_01C06425.E11214C0
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 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 the=20
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 =

?<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; File=20
"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 help=20
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 =
<BR></FONT></DIV>
<DIV>&nbsp;</DIV></BODY></HTML>

------=_NextPart_001_0007_01C06425.E11214C0--

------=_NextPart_000_0006_01C06425.E11214C0
Content-Type: text/x-vcard;
	name="Emmon Simbo.vcf"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
	filename="Emmon Simbo.vcf"

BEGIN:VCARD
VERSION:2.1
N:Simbo;Emmon
FN:Emmon Simbo
ORG:OpenLink Software
TITLE:Professional Services Consultant
TEL;WORK;VOICE:0208 681 7701
TEL;WORK;VOICE:0468 573 573
TEL;WORK;FAX:02086817702
ADR;WORK;ENCODING=3DQUOTED-PRINTABLE:;;Amy Johnson House=3D0D=3D0A22-26 =
Dingwall Rd;Croydon;Surrey;CR0 9XF;United Kin=3D
gdom
LABEL;WORK;ENCODING=3DQUOTED-PRINTABLE:Amy Johnson House=3D0D=3D0A22-26 =
Dingwall Rd=3D0D=3D0ACroydon, Surrey CR0 9XF=3D0D=3D0AU=3D
nited Kingdom
ADR;HOME:;;;;;;United Kingdom
LABEL;HOME:United Kingdom
URL:http://www.openlink.co.uk
URL:http://www.openlinksw.co.uk
EMAIL;PREF;INTERNET:esimbo@openlinksw.co.uk
REV:20001106T182603Z
END:VCARD

------=_NextPart_000_0006_01C06425.E11214C0--