[Zope-DB] Problem installing zodbca ODBC driver
George Perry
PerryG@esi.com
Tue, 20 May 2003 16:45:50 -0700
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
folder:
~~~~~~~~~~~~~~~~
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
win32
~~~~~~~~~~~~~~~~
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
import_product
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