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

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

OK so just for curiosity :

According to windows file properties, the version of my 
c:\oracle\ora9i\bin\oci.dll is 9.0.1.1.1

It is the version which DOESN'T work with cx_Oracle-4.0.1-win32-9i-py23 
but which WORKS with cx_Oracle-4.0.1-win32-8i-py23.

Normal ?

Philip.

Anthony Tuininga wrote:
> Interesting. What client version are you using, exactly? You wouldn't 
> happen to be using 9.0.1, would you? The 9i version of cx_Oracle will 
> not work with an 8i client at all but it should work with a 9i client -- 
> we've never noticed otherwise, anyway. Regardless, if you have it 
> working now, no need to continue this thread except from curiousity, of 
> course! ;-)
> 
> Philip SION wrote:
> 
>> Sorry but no :-(
>>
>> cx_Oracle-4.0.1-win32-9i-py23 did'nt work with either the 9i or 81 
>> version of oci.dll, and cx_Oracle-4.0.1-win32-8i-py23 works with both 
>> 9i and 81 version of the DLL...
>> (I switch from one DLL to the other by renaming the one I don't want 
>> to Aci.dll).
>>
>> So I will go on like this for the moment...
>>
>> Thanks,
>>
>> Philip.
>>
>> Anthony Tuininga wrote:
>>
>>> This is definitely an Oracle client issue -- the server software is 
>>> irrelevant, actually. In general, make sure that if you are running 
>>> Oracle 8i on the client you are using the Oracle 8i version of 
>>> cx_Oracle and if you are running Oracle 9i on the client make sure 
>>> you are using the Oracle 9i version of cx_Oracle. As mentioned 
>>> earlier, the only exception is Oracle 9.0.1 which doesn't have the 
>>> required procedure. Make sense?
>>>
>>> Nik Barron wrote:
>>>
>>>>> 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 ?
>>>>>   
>>>>
>>>>
>>>>
>>>>
>>>> It's complicated. It appears to depend on both the server and client
>>>> versions installed. I had to recompile cx_Oracle for one of our
>>>> configurations (8i client/server) although foolishly didn't write 
>>>> down the
>>>> step by step process (but it was pretty much in line with the docs I
>>>> recall).
>>>>
>>>> This is more of an Oracle issue than cx_oracle I think; I've had 
>>>> similar
>>>> problems with a number of client-side tools that interact with Oracle
>>>> directly, often having to swap ORACLE_HOME according to which 
>>>> specific tool
>>>> was being used!
>>>>
>>>> Nick Barron
>>>>
>>>>
>>>> -------------------------------------------------------
>>>> 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
>>>
>>
>>
>>
>> -------------------------------------------------------
>> 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
>