Page 1 of 1

RAC connection string

Posted: Thu 17 Feb 2011 23:04
by PlanetPaolo
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

Posted: Fri 18 Feb 2011 11:02
by Shalex
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?

Posted: Thu 27 Oct 2011 22:23
by slaxman
We need this feature as well--badly. where is it in your roadmap?

Posted: Mon 31 Oct 2011 10:56
by Shalex
We cannot provide any timeframe concerning RAC support in the Direct mode.