I am creating a new dabase application using VS2008, c#, Oracle 11 database, and Oracle 11g ODAC 11.1.0.7.20 with Oracle Developer Tools for Visual Studio. The database server is running win32. The developing computer is a 64bit processor running win32. I am getting the following error: "Unable to find the requested .Net Framework Data Provider. It may not be installed."
I am able to retreive and update data using a gridview with no problems as long as they are text, date columns, or hardcoded (text and values typed directly into the aspx page) combox columns. If I change the comboboxcolumn and point it to a DataSourceID and put it in edit mode I get the above error. If I add a combobox directly to a form and point it to the same DataSourceID and run the form the data displays in the combobox and can be selected. Everything I find concerning this error points to making sure the web.config and machine.config file are updated. I believe mine are. Do you have any suggestions:
Web.config:
<compilation debug="true">
<assemblies>
...
<add assembly="Oracle.DataAccess, Version=2.111.7.20, Culture=neutral, PublicKeyToken=89B483F429C47342"/>
<add assembly="Oracle.Web, Version=2.111.7.20, Culture=neutral, PublicKeyToken=89B483F429C47342"/>
...
</assemblies>
</compilation>
Machine.config:
<configuration>
<configSections>
<section name="oracle.dataaccess.client" type="System.Data.Common.DbProviderConfigurationHandler, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
</configSections>
<system.data>
<DbProviderFactories>
<add name="Oracle Data Provider for .NET" invariant="Oracle.DataAccess.Client" description="Oracle Data Provider for .NET" type="Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess, Version=2.111.7.20, Culture=neutral, PublicKeyToken=89b483f429c47342" />
<add name="OracleClient Data Provider" invariant="System.Data.OracleClient" description=".Net Framework Data Provider for Oracle" type="System.Data.OracleClient.OracleClientFactory, System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
</DbProviderFactories>
</system.data>
</configuration>