I have VS2012 and the latest 32-bit version of ODAC (Release 5 with Oracle Developer Tools) installed on a Win7 box. Everything is a clean install. In this environment, I have an ASP.NET Web Forms solution that was originally developed in VS2010 with EDMX files that were built on 32-bit ODAC Release 4.
I am able to set up connections to the database and view tables using Server Explorer, but I am now unable to modify my EDMX files via the Update Wizard. No tables will show in the Update Wizard.
Here is the connection string from the first step of the VS2012 Update Wizard:
metadata=res://*/Models.EventModel.EventModel.csdl|
res://*/Models.EventModel.EventModel.ssdl|
res://*/Models.EventModel.EventModel.msl;
provider=Oracle.DataAccess.Client;
provider connection string="data source=<serverid>;
persist security info=True;
user id=<userid>"
However, on my other Win7 box, I have clean installs of VS2010, EF 4.1, and the previous 32-bit version of ODAC (Release 4) with the exact same ASP.NET solution, yet I have no problems with Update Wizard.
Here is the Update Wizard connection string from VS2010 and ODAC4:
metadata=res://*/Models.EventModel.EventModel.csdl|
res://*/Models.EventModel.EventModel.ssdl|
res://*/Models.EventModel.EventModel.msl;
provider=Oracle.DataAccess.Client;
provider connection string="DATA SOURCE=<serverid>;
PASSWORD=;
PERSIST SECURITY INFO=True";
USER ID=<userid>"
Other related info:
1) I am using the web.config from my VS2010/ODAC4 solution in my VS2012/ODAC5 solution.
2) I have set the VS2012 solution to target .NET 4.5.
3) I have made sure that EF5 is installed via NuGet and I have installed VS2012 Update 1.
4) I also set up a box with a clean install of VS2010 and ODAC5, and I encounter the same problem. No tables in Update Wizard.
Questions:
Are there any web.config settings or other settings that I need to change to solve this problem? If so, what are the settings?
Thanks in advance for your help. I'd really like to get going with the new ODAC and VS2012.