[Zope-DB] Summary: Problem installing zodbca ODBC driver

George Perry PerryG@esi.com
Wed, 21 May 2003 11:14:54 -0700

I have achieved success, thanks to the kind support of the members of this
list.  Here is a summary of what worked for me:

Larry McDonnell was kind enough to e-mail a copy of the
ZODBCDA-3.1.0b2-win32-py21.tgz file that he had successfully installed on a
similarly configured workstation.

I installed this file using WinZip V8.0 with the option "TAR file smart
CR/LF conversion" turned on.

I then started Zope (running as a service).

When I inspected the Zope Control_Panel|Products folder, I saw ZODBCDA as an
"Installed Product".  When I inspected the Add objects drop down widget, I
saw a "Z ODBC Database Connection" as an entry on the list.

Thanks to everyone for their help, and my apologies for my rant on Open
Source vs Proprietary tools.


-----Original Message-----
From: George Perry [mailto:PerryG@esi.com]
Sent: Tuesday, May 20, 2003 4:46 PM
To: 'zope-db@zope.org'
Subject: [Zope-DB] Problem installing zodbca ODBC driver

I am a ZOPE newbie, so please have patience with me.

Yesterday I installed Zope on my MSWin2K workstation, using the
Zope-2.6.1-win32-x86.exe installation file from zope.org.  It seems to be
running as expected.  Here is the version info from the Zope Control_Panel
Zope Version
(Zope 2.6.1 (binary release, python 2.1, win32-x86), python 2.1.3, win32)
Python Version
2.1.3 (#35, Apr 8 2002, 17:47:50) [MSC 32 bit (Intel)]
System Platform
I tried to install the ZODBCA ODBC driver, which I also downloaded from
zope.org.  The installation seemed to have gone properly, with the files
ending up in:
 <ZOPE DIR>\lib\python\products\zodbcda

I was expecting to be able to add a ODBC object from the Add widget in the
root folder.  I did not see any appropriate entry to do this.  

In the Zope Control_Panel|Products|ZODBCDA tree, I see the following:
Import Traceback

Traceback (most recent call last):
  File "C:\PROGRA~1\SandBox\lib\python\OFS\Application.py", line 541, in
    product=__import__(pname, global_dict, global_dict, silly)
  File "C:\PROGRA~1\SandBox\lib\python\Products\ZODBCDA\__init__.py", line
91, in ?
    import DA
  File "C:\PROGRA~1\SandBox\lib\python\Products\ZODBCDA\DA.py", line 92, in
    from db import DB, manage_ODBCDataSources
  File "C:\PROGRA~1\SandBox\lib\python\Products\ZODBCDA\db.py", line 86, in
    from sql import *
ImportError: DLL load failed: Access is denied.
The ZODBC download page on zope.org states that I need to use the proper
version.  Just to be safe, I have tried both version 3.1.0b2 files (deleting
the installation directory between installs.

Thanks in advance for any insight about what I need to do differently.

Thank you,
George Perry

Zope-DB mailing list