what is the correct connection string for oracleConnect EF 6 in OCI Mode?

what is the correct connection string for oracleConnect EF 6 in OCI Mode?

Postby anand123 » Wed 19 Feb 2014 11:31

what is the correct connection string for oracleConnect EF 6 in OCI Mode? I have oracle client installed in all the machines. But I need to give different types of connection string for different machines. Advise correct the format.

Code: Select all
metadata=VMOracle.csdl|VMOracle.ssdl|VMOracle.msl;provider=Devart.Data.Oracle;provider connection string="User ID=SYSADM; Password=SYSADM; Connection Timeout=30;Data Source=ORCHDB17;”

metadata=VMOracle.csdl|VMOracle.ssdl|VMOracle.msl;provider=Devart.Data.Oracle;provider connection string="USER ID=SYSADM;CONNECTION TIMEOUT=30;PASSWORD=SYSADM;DATA SOURCE=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = IPADDRESS)(PORT = 1521))(CONNECT_DATA = (SID = ORCHDB17)))"

metadata=VMOracle.csdl|VMOracle.ssdl|VMOracle.msl;provider=Devart.Data.Oracle;provider connection string="User ID=SYSADM;Password=SYSADM;Connection Timeout=30;Data Source=IPADDRESS/ORCHDB17;";


thanks
anand
anand123
 
Posts: 15
Joined: Thu 30 Jan 2014 08:58

Re: what is the correct connection string for oracleConnect EF 6 in OCI Mode?

Postby Shalex » Fri 21 Feb 2014 13:16

All three formats are correct.

Have you encountered a problem with any of these formats?
Shalex
Devart Team
 
Posts: 7612
Joined: Thu 14 Aug 2008 12:44

Re: what is the correct connection string for oracleConnect EF 6 in OCI Mode?

Postby anand123 » Thu 06 Mar 2014 07:26

after the DNS entry, all 3 format is working fine. anyway in our application, DNS entry is must.

thanks
anand
anand123
 
Posts: 15
Joined: Thu 30 Jan 2014 08:58


Return to dotConnect for Oracle