Hi,
We have been using Direct mode whilst developing our application (using Entity Framework) and our connection strings looks like this:
connectionString=
"metadata=[...omitted...]
provider=Devart.Data.Oracle;
provider connection string = "
Server=;Port=1521;User Id=;Password=;Direct=true;SID=;
""
For deployment, we need to target a RAC server and we have been asked to use the service_name instead of the SID.
I know that Direct mode is not applicable in this case.
Could you please advise how the above connection string should look like to meet the specified requirements?
Thank you in advance,
Paolo
RAC connection string
-
- Posts: 1
- Joined: Thu 17 Feb 2011 22:47
- Location: Adelaide, Australia
There are two connection modes: OCI (via Oracle Client) and Direct. RAC is supported in the OCI mode. In the Direct mode you can connect only to one database instance (doesn't matter whether SID or Service Name is used to identify this single instance). We will investigate the possibility of implementing the RAC support in the Direct mode but there is no timeframe.
any updates on this?
We need this feature as well--badly. where is it in your roadmap?