RAC connection string
Posted: 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
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