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

[anand123]

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

[Shalex]

All three formats are correct.

Have you encountered a problem with any of these formats?

[anand123]

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

thanks
anand