Re: [cx-oracle-users] OCI.DLL cannot be found ?

[Philip S. <phi...@cg...>]

*** Sorry I was wrong with the file name :-(

It's not pywin32-202.win32-py2.3 that I installed back but 
cx_Oracle-4.0.1-win32-8i-py23.exe (THERE IS NO RELATION WITH pywin32 AT 
ALL of course...)

BTW, (I owed you to reproduce the problem ;-) :

When using Python from the command line, you obtain 2 different dialog 
boxes depending on the error :

a) With oracle81/bin/oci.dll and oracle9i/bin/oci.dll on the disk and in 
the path :

When I use cx_Oracle-4.1.beta1-win32-9i-py23, or 
cx_Oracle-4.0.1-win32-9i-py23.exe, it displays a window stating 
(translated from french): "Procedure entry point OCISessionGet cannot be 
found in dynamic link library OCI.DLL

With IDLE, I have the following errormessage in the Python Shell : 
ImportError: DLL load failed: the specified procedure cannot be found

Errormessages match.

b) With both oci.dll renamed to aci.dll (so they are not any longer on 
the disk for the app)

This time the window is : This application could start because OCI.dll 
cannot be found. Re-installation of this application can solve this problem.

And Python Shell error is : ImportError: DLL load failed: the specified 
MODULE cannot be found !!!

So the PythonShell errormessage was OK (although a bit incomplete), I 
just read it too fast :-(

c) With cx_Oracle-4.0.1-win32-9i-py23.exe uninstalled and 
cx_Oracle-4.0.1-win32-8i-py23.exe installed back, oracle9i (or 
81)/bin/aci.dll renamed to the right name, everything runs fine.

Finally, am I using oracle 9i or 81 ??? It depends on the DLL I left on 
the machine ? Or is it the cx_oracle version which rules ?

Thanks a lot anyway.

Philip.

Anthony Tuininga wrote:

> Glad to hear you got it working. Just so that others who might run into 
> this problem have something to look at in the archives and so that I 
> understand it a bit better, could you answer a few questions?
> 
> 1) what was the clearer error message that was displayed when running 
> Python from the command line?
> 
> 2) What did you do after the installation of pywin32-202.win32-py2.3 
> that caused it to "link OK" aginst Oracle 8i's oci.dll?
> 
> Thanks.
> 
> Philip SION wrote:
> 
>> It works !!!
>>
>> Thanks for your help to you all.
>>
>> In fact, both cx_Oracle-4.0.1-win32-9i-py23 and 
>> cx_Oracle-4.1.beta1-win32-9i-py23 where unable to found the entry 
>> point in the oci.dlls I have on my machine (although I own both 81 and 
>> 9i versions). I had a clearer errormessage when running python from 
>> the command line.
>>
>> So I installed the pywin32-202.win32-py2.3 and it linked OK against 
>> the Oracle 81's OCI.DLL.
>>
>> I can go on testing now...
>>
>> Philip.
>>
>> Nik Barron wrote:
>>
>>>> I believe Visual Studio includes (included) an utility called
>>>> depends.exe which did this.
>>>
>>>
>>>
>>>
>>> There's a freeware equivalent at http://www.dependencywalker.com/ that's
>>> pretty good.
>>>
>>> Nick Barron
>>>
>>>
>>> -------------------------------------------------------
>>> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
>>> Project Admins to receive an Apple iPod Mini FREE for your judgement on
>>> who ports your project to Linux PPC the best. Sponsored by IBM.
>>> Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
>>> _______________________________________________
>>> cx-oracle-users mailing list
>>> cx-...@li...
>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>>
>>
>>
>>
>> -------------------------------------------------------
>> This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
>> Use IT products in your business? Tell us what you think of them. Give us
>> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out 
>> more
>> http://productguide.itmanagersjournal.com/guidepromo.tmpl
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> 
>