[Zope] ZOracleDA isn't imported in Zope

[Hannu Krosing]

Alexei Ustyuzhaninov wrote:
>
> Hi zopsters!
> 
> I have installed Oracle adapter in my system and when I try to click on
> ZOracleDA product in Control Panel I will get the following output:
> 
> Product at /Control_Panel / Products / ZOracleDA
> 
> ZOracleDA Import Traceback
> 
> Traceback (innermost last):

...

>     import DCOracle, DateTime
>   File "E:\Program Files\Python\Lib\DCOracle\__init__.py", line 66, in ?
>     from ocidb import Connect, error
>   File "E:\Program Files\Python\Lib\DCOracle\ocidb.py", line 50, in ?
>     import oci_, ociCurs, ociProc
> ImportError: DLL load failed: Access is denied.
> 
> The funniest thing about this is that I can import either ZOracleDA or
> DCOracle in python window as well as connect to Oracle server with
> DCOracle tools.
> 
> Can anybody help me with this please?

there are two possibilities I can think of:

1. Your Zope server runs as another user than you and it has nor reading 
rights for directories and files making up the product

2. The oracle environment is not set up for the Zope process

-------------
Hannu