I prescribe:

import cx_Oracle conn = cx_Oracle.connect('login/password@server/alias')

It produces the following error:

cx_Oracle.DatabaseError: DPI-1047: 64-bit Oracle Client library cannot be loaded: "C: \ Oracle \ product \ 11.2.0 \ client_1 \ bin \ oci.dll is not the correct architecture".

The python and oracle version is 64-bit. What could be the problem?

  • In PATH link is one and to the correct client? - Eugene Dennis
  • Do I understand correctly that I should have a path to the interpreter there, In my case .. \ AppData \ Local \ Continuum \ Python36? - medyaniklis
  • C: \ Oracle \ product \ 11.2.0 \ client_1 \ bin; C: \ ProgramData \ Oracle \ Java \ javapath; C: \ Windows \ system32; C: \ Windows; C: \ Windows \ System32 \ Wbem; C: \ Windows \ System32 \ WindowsPowerShell \ v1.0 \; C: \ Users \ emedyanik \ AppData \ Local \ Continuum \ Python36 - medyaniklis
  • somewhere in your architecture (bit depth) does not match - check the Python architecture, Oracle Client, cx_Oracle - MaxU
  • Yes you are right. I checked the server for architecture, it is 64, and the client was 32 - medyaniklis

0