Oracle Data Provider for .NET / ODP.NET connection strings

Using TNS Data Source=TORCL;User Id=myUsername;Password=myPassword; Example: Data Source=localhost:1521/orcl; User Id=scott; Password=scott; Using integrated security Data Source=TORCL;Integrated Security=SSPI; Using ODP.NET without tnsnames.ora Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MyOracleSID))); User Id=myUsername;Password=myPassword; Using the Easy Connect Naming Method (aka EZ Connect) The easy connect naming method enables clients to connect to a database without any configuration. Data Source=username/[email protected]//myserver:1521/my.service.com; Port 1521 is used… Continue reading Oracle Data Provider for .NET / ODP.NET connection strings