DPI-1047: 64-bit Oracle Client library cannot be loaded

handyman_hank

I am trying to run oracle database in python. Specifications: 1. Windows 7 64 bit 2. Python 32 bit 3.6 (Running on Jupyter(Anaconda Navigator) 3.Visual studio 2010 training kit module 4.Oracle instant client basic 12.2 32 bit 5.Oracle instant client basic SQL*Plus 12.2 32 bit I have installed cx_Oracle via command import sys !conda install --yes --prefix {sys.prefix} cx_Oracle import cx_Oracle After that I have installed Oracle instant client...

Originally asked by Kshitiz Tiwari on Stack Exchange (stackoverflow) (CC BY-SA 4.0).

uphilltech

Great question — answering as the UphillTech team:

You need to install 64-bit Instant Client not 32-bit - the error is clear about this. When you run Python make sure Instant Client is in your PATH environment variable before the Oracle 10.2 directory, or any other Oracle libraries.

Full answer by Christopher Jones: https://stackoverflow.stackexchange.com/a/51623236 (CC BY-SA 4.0).

Need it done for your business? UphillTech.