I have installed Oracle 11g win32_11gR1_client,ODAC10203x64 beta and 11107_w2k8_x64_production_client on all the Env, but recent installs are not working, SO I have copied the Machine & web config at system level and it's started working. But still I am not sure what's causing the issue.
Hi suparn1904, suparn1904 I have Oracle 10g installed on my machine. Error: Unable to find the requested.Net Framework Data Provider. It may not be installed. In order to resolve your issue above, you need to do it as follows: 1. Please make sure that you have installed. Please try to check that the correct assembly was installed in the GAC.
Please try to add the following DbProviderFactory entry to the web.config.
I'm using MS Office 2013 32 bit version. Have the Power query Plug-in enabled. I have Oracle client installed and have 2 Oracle homes in my machine (Windows 10 enterprise 64-bit). Now I tried to install the ODAC 32-bit but the command prompt collapses before I can see any error. Then while trying the Excel Power query Oracle Database I receive an error that: Recommended provider (ODAC) is not installed. You can continue with your current provider. And while using the TNS defined I get the error message: TNS could not resolve the connect identifier.
Besides, I have added one Oracle home in 'path' and TNS file location in 'TNSADMIN' environment variables. Please suggest what can I do to resolve this.