This discussion is archived
7 Replies Latest reply: Jan 21, 2013 7:53 AM by Tridus RSS

ODP.Net 11g not in Data Source list in Server Explorer in VS

896516 Newbie
Currently Being Moderated
I recently installed 64-bit ODAC 11.2.0.2.50 Beta 3 which includes Oracle Data Provider for .NET 4 11.2.0.2.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
Oracle Database
<other>

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 11.2.0.1.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?
Thank you,

Craig

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points