[Zope] Re: ZOracleDA isn't imported in Zope

[Alexei Ustyuzhaninov]

This is a multi-part message in MIME format.
--------------80AF256A9A10A13BC5B92D9F
Content-Type: text/plain; charset=koi8-r
Content-Transfer-Encoding: 7bit

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):
>   File "E:\PROGRA~1\kayak\lib\python\OFS\Application.py", line 393, in
> import_products
>     product=__import__(pname, global_dict, global_dict, silly)
>   File "E:\PROGRA~1\kayak\lib\python\Products\ZOracleDA\__init__.py",
> line 103, in ?
>     import DA
>   File "E:\PROGRA~1\kayak\lib\python\Products\ZOracleDA\DA.py", line
> 103, in ?
>     from db import DB
>   File "E:\PROGRA~1\kayak\lib\python\Products\ZOracleDA\db.py", line
> 101, in ?
>     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?
> 
> The configuration is as follows: WinNT 4.0, Zope 2.0.1, ZOracleDA 2.1.0,
> DCOracle 1.3.0.

Debugging sources of DCOracle shows following root of all evil:

When DCOracle is called from zope and ZOracleDA and, in turn, it calls
Oracle OCI function olog to connect to database. This call fails with
return code -3121. It means "ORA-03121: no interface driver connected -
function not performed". The problem in first message looks like the
result of incorrect processing of this error in ZOracleDA. When DCOracle
is called directly from python window the call to olog with absolutely
the same arguments ends up with no error.

It seems that the final problem is in Oracle software. But what the
difference  to Oracle between these two calls to olog?

Thanks,
--------------80AF256A9A10A13BC5B92D9F
Content-Type: text/x-vcard; charset=koi8-r;
 name="AUstyuzhaninov.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Alexei Ustyuzhaninov
Content-Disposition: attachment;
 filename="AUstyuzhaninov.vcf"

begin:vcard 
n:Ustyuzhaninov;Alexei
tel;work:(095) 795-05-20
x-mozilla-html:FALSE
url:http://www.flagship.ru
org:Flagship Telesystems;Business Requirements
adr:;;Profsoyuznaya str., 65;Moscow;;;Russia
version:2.1
email;internet:AUstyuzhaninov@flagship.ru
title:Analyst
fn:Alexei Ustyuzhaninov
end:vcard

--------------80AF256A9A10A13BC5B92D9F--