Hello,
I'm getting the dreaded ORA-28500 "Optional feature not implemented" when trying to access an Excel file through HS ODBC. This is a known bug in 11.1.0.6 (6701400), however my flavor is 11.1.0.7 fully patched. Since I'm trying to use the OLAP option on Windows XP 32, I installed version 11.1.0.6 and applied patches 6890831 and 7682184, as advised on [this page|http://www.oracle.com/technology/products/bi/olap/collateral/olap_certification.html], with no error as far as I can tell. This should have fixed the problem with dg4odbc according to the bug page, however when now I try to access an Excel sheet I get the exact same message :
SQL> select * from "International$"@refdata;
select * from "International$"@refdata
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Microsoft][ODBC Excel Driver]Optional feature not implemented
ORA-02063: preceding 2 lines from REFDATA
Is it possible that the patch did not go as intended ? Or that the second patch did reintroduce the old behavior ? I'm really lost at what to do now.
Thanks for your help,
Chris