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:
- username
- password
- 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