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

[Anthony T. <an...@co...>]

Ah yes, the infamous "OCISessionGet" procedure entry point missing 
error. We have the same error occur on a regular basis when someone with 
an Oracle 8i client installation attempts to run an Oracle 9i version of 
cx_Oracle. Running an Oracle 8i version of cx_Oracle on either an 8i or 
9i installation (on Windows) does not have a problem. In general, 
however, you need to make sure that your client software matches the 
version of cx_Oracle that you are using. The server software version is 
completely irrelevant. The only funny exception is Oracle 9.0.1 (an 
early version of 9i) which does not have the OCISessionGet() method 
either. Hope that clears up any questions you might have. If not, feel 
free to ask more questions!

Philip SION wrote:

> *** 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
>>
>>
>>
>
>
>
> -------------------------------------------------------
> 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