This content has been marked as final. Show 1 reply
lumis wrote:As far as I can tell, same components should be provided with XE.
1. whether I need to install additional ODAC package or maybe it is already included in the XE server version and need to be somehow activated
OLE DB is listed as an available app dev's feature:
I have other Oracle Database software installed on my machine, which may have overwritten OraOLEDB (there can be only one...), so I can't verify for XE 11.2. On another machine with 10.2 XE, OraOLEDB exists from XE install.
However in 11.2, in the server\bin folder OraOLEDB11.dll etc. files exist. (But as said, can't verify if installer registerred OraOleDb.).
Note however that win x64 is not on the list of supported/system requirements. The x64 version have been about to be released for a year. XE 11.2 Windows 64
Maybe that wouldn't help in OLE DB case either, if you needed 32-bit data provider.
2. If ODAC installation is required which version should I choose (32 or 64 bit)?If Excel is 32-bit, you would need 32-bit connectivity/data access software.
See ODAC otn page for downloads, instructions, etc.
OraOleDb provider has its own forum, in the Win and .Net section.
Edited by: orafad on Sep 20, 2012 1:31 PM