Hi,
We're trying to deploy our application on a server which does not have Oracle client installed. We're using the managed dataAccess dll with entity framework 5. Our web.config file contains the following:
<connectionStrings>
<add name="CroEntities" connectionString="metadata=res://*/CroModel.csdl|res://*/CroModel.ssdl|res://*/CroModel.msl;provider=Oracle.ManagedDataAccess.Client;provider connection string="DATA SOURCE=oracle;PASSWORD=password;PERSIST SECURITY INFO=True;USER ID=user"" providerName="System.Data.EntityClient" />
</connectionStrings>
<Oracle.ManagedDataAccess.Client>
<version number="4.121.1.0">
<dataSources>
<dataSource alias="oracle" descriptor="(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = myhost.bc.ca)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = serviceName.bc.ca)))" />
</dataSources>
</version>
</Oracle.ManagedDataAccess.Client>
Oracle.ManagedDataAccess.dll is in our Bin folder.
When running, we get the following error: ORA-12541: TNS: No listener.
The listener is working fine. My thinking is that something is missing in our configuration. When we add debug information for the value of context.Database.Connection.Database we get empty string which make me think that the the information in the config file is not making it to the application at run time.
Any thought on what could be missing?
Thank you,
Ken