Omiting tnsnames.ora Alternative using Microsofts OracleConnection

Connection string

This .NET Framework Data Provider for Oracle connection string can be used for connections to Oracle.

Some reported problems with the one above and Visual Studio. Use the next one if you've encountered problems.

Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));
User Id=myUsername;Password=myPassword;