Cannot connect to Oracle database, python not recognizing cx_Oracle

3031421

Hi I am trying to connect to an Oracle Database using pycharm as my IDE.  I've downloaded and installed the cx_oracle from https://pypi.python.org/pypi/cx_Oracle/5.3 

However when I try to run:

import cx_Oracle, I receive an import error, and am completely stuck as to what to do next.  Any help will be appreciated.

3031421

Hi @Anthony Tuininga-Oracle, thanks for posting.

Firstly I should have posted more info like I'm on Windows 10, and 64 bit. 

This link helped me immensely:  http://stackoverflow.com/questions/5809195/installing-oracle-instant-client

The key for me was installing the 64 bit version of python, the 64 bit cx_Oracle dll and pointing the windows environment variable path values to the correct directory location. 

Anthony Tuininga-Oracle

An Oracle Client is required for cx_Oracle to work. The easiest Oracle Client that can be installed is the Instant Client which you can find here: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html. Follow the instructions at the bottom of the page for your platform. In particular, ensure that either the "Basic" or "Basic Light" package is installed.

3031421

Hi @Anthony Tuininga-Oracle, thanks for posting.

Firstly I should have posted more info like I'm on Windows 10, and 64 bit. 

This link helped me immensely:  http://stackoverflow.com/questions/5809195/installing-oracle-instant-client

The key for me was installing the 64 bit version of python, the 64 bit cx_Oracle dll and pointing the windows environment variable path values to the correct directory location.