Windows 10 64bit DPI-1047 Error

[RT7QGJiA2ZW]

Answer the following questions:

1. What is your version of Python? Is it 32-bit or 64-bit?
   Python 3.7.3 64bit Miniconda Install

2. What is your cx_Oracle version?
   7.2.1

3. What exact command caused the problem (e.g. what command did you try to install with)? Who were you logged in as?
   When executing the connection in Jupyter Notebook: df = pd.read_sql(query, con=conn)

4. What error(s) you are seeing?
   DPI-1047 Cannot locate a 64-big Oracle Client Library

5. What OS (and version) is Python executing on?
   Windows 10 64bit

6. What is your version of the Oracle client (e.g. Instant Client)? How was it installed? Where is it installed?
   Instant Client 19.3 unzipped and installed to c:\instantclient_19_3 and has also been added to the windows path.

7. What is your Oracle Database version?
   12.2

8. What is the PATH environment variable (on Windows) or LD_LIBRARY_PATH (on Linux) set to? On macOS, what is in ~/lib?
   %USERPROFILE%\AppData\Local\Microsoft\WindowsApps;C:\instantclient_19_3

9. What Oracle environment variables did you set? How exactly did you set them?
   None

10. Do you have a small, single Python script that immediately runs to show us the problem?

[RT7QGJiA2ZW]

Visual Studio 2013 VC++ 12.0 x64 has also been installed from here https://support.microsoft.com/en-us/help/4032938/update-for-visual-c-2013-redistributable-package

Using the Instant Client Basic package 64 bit

[cjbj]

Nothing obviously wrong stands out, so triple check everything. Make sure you got the 64-bit Instant Client, make sure PATH is really set prior to the time pythons run, etc.

[RT7QGJiA2ZW]

One thing I am unsure about is the installation of cx_oracle. I've used Miniconda as the manager for Python3 but the Anaconda package is cx_oracle 7 as opposed to the current realease 7.2.1 so I installed cx_oracle using pip rather than Anaconda. I'm not sure if that would cause any issues or not.

Also I only have Python 3 installed so I'm not running it side by side with Python 2 and it was a fresh install.

[anthony-tuininga]

I don't know whether mixing pip and Anaconda would cause problems or not as I have not used Anaconda much at all. If you have discovered the answer to your question, please note it here. I'm going to close this for now.