2 Replies Latest reply: Aug 24, 2014 11:13 PM by sdhamoth RSS

    How To Connect To Oracle 11g Database From Microsoft Excel

    Vishwamber Shetty-Oracle

      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