I recently installed 64-bit ODAC 18.104.22.168.50 Beta 3 which includes Oracle Data Provider for .NET 4 22.214.171.124.50. In Visual Studio 2010, I go to Server Explorer, right-click on Data Connections, and click Add Connection. In the list of Data Sources, I have:
Microsoft Access Database File
Microsoft ODBC Data Source
Microsoft SQL Server
Microsoft SQL Server Database File
When I choose Oracle Database, there are two options in the Data provider dropdown: .NET Framework Data Provider for Oracle and .NET Framework Data Provider for OLE DB.
When I select either of these and click Continue, the next screen shows my Data Source as: Oracle Database (OracleClient). I believe what I am supposed to see is: Oracle Database Server (Oracle ODP.NET)
I also have the 64-bit 11g 126.96.36.199.0 Enterprise Edition of Oracle installed and I am able to successfully connect to the database I created by using SQL Plus.
Can someone please tell me what I am missing?
Yep. That worked for me. I actually uninstalled the 64-bit Oracle and client because I was having trouble installing the 32-bit client, even in a separate Home folder. So now I am running both 32-bit Oracle and a 32-bit client and VS 2010 easily finds my database.
I recently installed the ODAC 32-bit using the Oracle Universal Installer (OUI). I was able to connect to the server using code and Server Explorer. For the deployment on staging I am not allowed to use an installer so I uninstalled it and installed the XCopy version of ODAC 32-bit. Now I can connect to server using code but the server explorer is not showing ODP in the list of data providers.
I have also executed the following command-line utils:
c:\ora32>configure all ORA32 true
c:\ora32\odp.net\bin\4>OraProvCfg.exe /action:config /product:odp /frameworkversion:v4.0.30319 /providerpath:"C:\ora32\odp.net\bin\4\Oracle.DataAccess.dll"
and 2.x version of the same
The solution is to use 32-bit ODAC with ODT installation, not the xcopy version. The xcopy version is intended for deployment time, not development time. Thus, the xcopy version does not contain any Oracle tools.
To further Alex's answer, the xcopy version contains the necessary files to use anything you build with the installer version. The only thing missing is the developer tools themselves, and you don't need those on your staging/production systems.