RAC connection string

RAC connection string

Postby PlanetPaolo » Thu 17 Feb 2011 23:04

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
PlanetPaolo
 
Posts: 1
Joined: Thu 17 Feb 2011 22:47
Location: Adelaide, Australia

Postby Shalex » Fri 18 Feb 2011 11:02

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.
Shalex
Devart Team
 
Posts: 7530
Joined: Thu 14 Aug 2008 12:44

any updates on this?

Postby slaxman » Thu 27 Oct 2011 22:23

We need this feature as well--badly. where is it in your roadmap?
slaxman
 
Posts: 47
Joined: Wed 16 Sep 2009 20:09
Location: United States

Postby Shalex » Mon 31 Oct 2011 10:56

We cannot provide any timeframe concerning RAC support in the Direct mode.
Shalex
Devart Team
 
Posts: 7530
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle