Entity Data Model Wizard not showing Oracle's Data Provider in New Conn
709788Jun 10 2011 — edited Jun 13 2011Not sure where the problem lies - with Visual Studio or with Oracle or with me.
I have Visual Studio 2010 and Oracle Client installed on a 64 bit Windows 7 machine. In the Server Explorer, I can add a new connection using ODP.NET data provider, and test it successfully. I can also use the query window to run commands using that connection. The problem occurs when I try to add ADO.NET Entity Data Model using (right-click) Add New Item to the solution. Entity Data Model Wizard opens and I choose Generate from database. The next page does NOT show the connection to Oracle that I added from Server Explorer. If I try to add a new connection from this window, Oracle is not an option in Choose a DataSource window. If I select Other, then ODP.NET does not appear in the dropdown for Data Provider. What do I need to do to get the Oracle connection and/or ODP.NET provider to show up in the EDM Wizard? Here is the VS 2010 configuration on my machine:
Microsoft Visual Studio 2010
Version 10.0.30319.1 RTMRel
Microsoft .NET Framework
Version 4.0.30319 RTMRel
Installed Version: Premium
Microsoft Visual C# 2010 01021-532-2002467-70359
Microsoft Visual C# 2010
Microsoft Visual F# 2010 01021-532-2002467-70359
Microsoft Visual F# 2010
Microsoft Visual Studio 2010 Code Analysis Spell Checker 01021-532-2002467-70359
Microsoft Visual Studio 2010 Code Analysis Spell Checker
Portions of International CorrectSpell™ spelling correction system © 1993 by Lernout & Hauspie Speech Products N.V. All rights reserved.
The American Heritage® Dictionary of the English Language, Third Edition Copyright © 1992 Houghton Mifflin Company. Electronic version licensed from Lernout & Hauspie Speech Products N.V. All rights reserved.
Microsoft Visual Studio 2010 Team Explorer 01021-532-2002467-70359
Microsoft Visual Studio 2010 Team Explorer
Microsoft Visual Web Developer 2010 01021-532-2002467-70359
Microsoft Visual Web Developer 2010
Microsoft Windows Phone Developer Tools - ENU 01021-532-2002467-70359
Microsoft Windows Phone Developer Tools - ENU
Crystal Reports Templates for Microsoft Visual Studio 2010
Crystal Reports Templates for Microsoft Visual Studio 2010
Hotfix for Microsoft Visual Studio 2010 Premium - ENU (KB982218) KB982218
This hotfix is for Microsoft Visual Studio 2010 Premium - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/982218.
Microsoft Visual Studio 2010 SharePoint Developer Tools 10.0.30319
Microsoft Visual Studio 2010 SharePoint Developer Tools
Microsoft XNA Game Studio 4.0
Microsoft XNA Game Studio 4.0
Build 4.0.20823.0
Oracle Developer Tools for Visual Studio 11.2.0.1.2
Oracle Developer Tools for Visual Studio Copyright (c) 2005, 2010