what is the correct connection string for oracleConnect EF 6 in OCI Mode?
Posted: 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.
thanks
anand
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;";
anand