7 Replies Latest reply: Jan 21, 2013 9:53 AM by Tridus RSS

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

    896516
      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