Avatar of Scarlett72
Scarlett72
 asked on

Cannot connect to Oracle database, python not recognizing cx_Oracle

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
PythonOracle Database

Avatar of undefined
Last Comment
Scarlett72

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
JesterToo

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Scarlett72

ASKER
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.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes