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 126.96.36.199.2 or higher you installed? ODAC 188.8.131.52 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.
Yes,you are right! Thanks.
But another problem occured:
After deploying project to IIS,I encounter another problem:canot find request .net framework data provider.
Now ,My ODAC is 184.108.40.206.0 32bit.OS is 2003 64bit.
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.
I am having the same type of issue with ODAC1020221 in Visual Studio 2010.
'((Oracle.DataAccess.Client.OracleException)($exception)).DataSource' threw an exception of type 'System.NullReferenceException'
I have installed ODTwithODAC1120320_32bit in my computer but I still can't see Oracle ODP.NET datasource in VS2010.
My computer's spec are:
Windows Server 2008 R2 Standard - 64 bit
Visual Web Devloper Express 2010 with SP1