My OS is windows server 2003 64bit.
My VS is 32bit VS2010.
After installing ODAC 11.1 32bit ,I can't find Oracle ODP.NET datasource in VS2010 while ODAC client sqlplus can conntect to oracle server.
So,how can I do?
Thanks,but uninstalling ODAC 11.1 ,I installed ODAC 11.2 instead.However,I still cannot find ODP.NET data provider in windows server 2003 64bit windows and server 2008 64bit .
So,can you give me some idea?
Was it ODAC 188.8.131.52.2 or higher you installed? ODAC 184.108.40.206 did not have VS 2010 support.
Make sure to install the Oracle Developer Tools for Visual Studio, which is part of ODAC. That allows ODP.NET to be used in Server Explorer. The tools are only available with the 32-bit ODAC download since Visual Studio is 32-bit only.
The most common reason I've seen for this error is a problem with their DBProviderFactories section of their machine.config file. It's possible that Oracle.DataAccess is missing or they have an extra <DbProviderFactories/> termination node that needs to be deleted.
Make sure you look at the correct machine.config file since there are multiple ones if you have 32-bit and x64 .NET Framework installed, as well as .NET Framework 4 and .NET Framework 2-3.5.