Oracle Database 11g Enterprise Edition Release 184.108.40.206.0 - 64bit Production
PL/SQL Release 220.127.116.11.0 - Production
CORE 18.104.22.168.0 Production
TNS for Linux: Version 22.214.171.124.0 - Production
NLSRTL Version 126.96.36.199.0 - Production
I have a solution developed in Visual Studio 2012 targetting .Net 4.0. Simplified: Startup project is a WPF library and supporting this library is another project that uses Entity Framework to retrieve data. I have copied the connection strings from my EF project to my startup project, and everything seems to work fine on the development machine.
However, as sson as this project is run on a user's desktop they get the error:
The specified store provider cannot be found in the configuration, or is not valid.
Stack trace (transcribed from screenshot, so there might be typos):
at System.Data.EntityClient.EntityConnection.ChangeConnectionString(String newConnectionString)
at System.Data.EntityClient.EntityConnection..ctor(String connectionString)
at System.Data.Entity.Internal.LazyInternalConnection.InitializeFromConnectionStringSetting(ConnectionStringSettings appConfigConnection)
at System.Data.Entity.Internal.,LazyInternalConnection.TryInitializeFromAppConfig(String name, AppConfig config)
at System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType)
at System.Data.Entity.Internal.Linq.InternalSet` 1.Initialize()
at System.Data.Entity.Internal.Linq.InternalSet` 1.get_InternalContext()
at System.Data.Entiy.Infrastructure.DbQuery` 1.System.Linq.IQueryable.get_Provider()
at System.Linq.Queryable.Where[TSource](IQueryable` 1 source, Expression` 1 predicate)
I've already verified that Oracle.DataAccess is referenced in my EF project, and I'm including oci.dll, orannzsbb11.dll, oraociei11.dll, and OraOps11w.dll in my main library (fat installation).
This configuration worked when using the older ADO.Net DataSets, but now I want to use EF 4.4 (DataBase first/model first/whatever it's not Code First) because it's just easier to code against. So obviously I'm missing something when it comes to deploying my solution. Any ideas?
Note that this is a desktop application using MS OneClick.
The specified store provider cannot be found in the configuration, or is not valid. ---> System.ArgumentException: Unable to find the requested .Net Framework Data Provider. It may not be installed.
You mention "Sounds like the client system doesn't have an Oracle client installed."
I am using Win Server 2008 R2. I have installed what i think is the right client. How do i tell?
What is the right client? Where do i get it?