Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How To Connect To Oracle 11g Database From Microsoft Excel

Vishwamber Shetty-OracleAug 24 2014 — edited Aug 25 2014

Hi All,

I have Windows7 64bit installed in my laptop.

I have Microsoft Excel 2007 installed.

I tried connecting to Oracle database ( This is not a local database).

Navigation used:

Data> From Other Sources > From Data Connection Wizard > Other/Advanced > Next > Microsoft OLE DB Provider For Oracle > OK

Now I get a pop up to enter:

  1. username
  2. password
  3. server

When I enter all the required details I get this error "ORA-06413 CONNECTION NOT OPEN"

Is there no need to give PORT number?

Thanks,

Vishwamber Shetty
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 22 2014
Added on Aug 24 2014
#odbc, #windows-and-net
2 comments
4,533 views