Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

We've recently installed a new piece of software that uses an Oracle Database to store the data. My goal is to connect to that database and pull the data from the back end to do analysis on. I'm having the world's most difficult time connecting to it.

I need to access it two ways:

  1. ODBC - I would like to setup an ODBC connection in Windows 7, so that I can pull the information using Excel. I know how to setup the connection, but I cannot for the life of me manage to setup the Oracle Drivers correctly. All the links from documentation for this piece of software go to dead/changed pages. Apparently the Oracle website has changed since this documentation was written.

  2. Python - From what I can tell, cx_Oracle seems to be the best module, but again I can't seem to set it up correctly. And again, most documentation refers to sections of the Oracle website that has since changed. I'm not sold on using cx_Oracle if someone has a better recommendation.

Thanks for looking over this, and I appreciate your help.

share|improve this question
    
What is your actual problem? Do you get errors when trying to set up the drivers? –  dezso Aug 30 '13 at 18:43
    
The best way to connect to Oracle from within Oracle is cx_Oracle. However, you might want to consider using Jython instead which you could call easily from within Oracle... –  Ben Sep 18 '13 at 21:05
add comment

1 Answer

Are you installing the 32 bit drivers or the 64 bit drivers on Windows 7?

I have to install the 32 bit drivers on all of our Windows 7 machines (even those running 64 bit).

After that I have to set up ODBC using: c:\windows\syswow64\odbcad32.exe instead of through the control panel.

Your issue may very well be different.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.