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

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

What version of Oracle are you using? If you are using 9.0.1 then you 
should be using the 8i version (which will work just fine with an Oracle 
9i client on Windows). 9.0.1 does not have the features that I took 
advantage of in the 9i version -- those all got added in 9.2.

BTW, I believe that SQL*Plus uses oci.dll just as much as cx_Oracle 
does. As for searching for DLLs, that is done using the standard Windows 
method: search the current directory, the directory in which the 
executable is found and the path, etc. Unfortunately, I don't believe 
there is anything equivalent to the Unix ldd command that displays what 
shared libraries will be loaded by a particular program.

Hope this helps.

Philip SION wrote:
> Hello !
> 
> I got the "standard" errormessage under WinXP :
> 
>  >>> import cx_Oracle
> Traceback (most recent call last):
>   File "<pyshell#6>", line 1, in ?
>     import cx_Oracle
> ImportError: DLL load failed: La procédure spécifiée est introuvable. 
> (the specified procedure cannot be found).
> 
> As I get the same message even if I wipe out all oci.dll from c:\, I 
> guess the errormessage does'nt mean "the is a problem with one entry 
> point in the dll" but rather "I cannot find the (oci.)dll".
> 
> I use latest cx_oracle 4.1 beta1 for 9.0i (installed with the installer 
> for python 2.3)
> Oracle 9.0i client is installed. oci.dll is in c:\oracle\ora9i\bin. 
> SQLPlus is working fine.
> 
> Here's my path :
> 
> PATH=c:\oracle\ora9i\bin;C:\Program 
> Files\Oracle\jre\1.1.8\bin;c:\oracle\ora81\bin;C:\Program 
> Files\Oracle\jre\1.1.7\bin;C:\WINNT\System32;C:\WINNT;C:\WINNT\System32\Wbem;c:\Prgfile\Orawin\bin;C:\PROGRA~1\CA\SHARED~1\SCANEN~1;C:\PROGRA~1\CA\ETRUST~1;C:\Program 
> Files\Visio2002\Visio10;c:\gs\gs8.14\bin\;C:\PROGRA~1\ULTRAEDT;Z:.;
> 
> And I even set :
> 
> ORACLE_HOME=c:\oracle\ora9i\
> 
> How does cx_oracle.pyd look for oci.dll ? How to solve this problem ?
> 
> Thanks a lot for any hint !
> 
> Philip.
> 
> 
> 
> 
> -------------------------------------------------------
> 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

-- 
Anthony Tuininga
an...@co...

Computronix
Distinctive Software. Real People.
Suite 200, 10216 - 124 Street NW
Edmonton, AB, Canada  T5N 4A3
Phone:	(780) 454-3700
Fax:	(780) 454-3838
http://www.computronix.com