We help IT Professionals succeed at work.

Cannot connect to Oracle database, python not recognizing cx_Oracle

Scarlett72 asked
Last Modified: 2018-02-02
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.

Error Message
Watch Question

This problem has been solved!
(Unlock this solution with a 7-day Free Trial)


Hi wanted to follow up.  Firstly I should have posted more info like I'm on Windows 10, and 64 bit.  
This link helped me immensely:  Stack Exchange
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.  Thanks for posting back JesterToo.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions