Autor YouCode - http://www.youcode.com.ar/visual-basic-net/oracle-modos-de-coneccion-desde-visual-basic-net-315
Diferentes metodos de conexion a Oracle, TNS,EZE,POOLING
TNSData Source=TORCL;User Id=myUsername;Password=myPassword;Usando la seguridad integrada
Data Source=TORCL;Integrated Security=SSPI;Usando ODP.NET sin utilizar el 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;EZ connect
Data Source=username/password@//myserver:1521/my.service.com;o
Data Source=username/password@myserver//instancename;Easy Connect a un servidor dedicado
Data Source=username/password@myserver/myservice:dedicated/instancename;Especificando parametros Pooling
Data Source=myOracle;User Id=myUsername;Password=myPassword;Min Pool Size=10; Connection Lifetime=120;Connection Timeout=60;Incr Pool Size=5;Decr Pool Size=2;Restringir el POOL SIZE
Data Source=myOracle;User Id=myUsername;Password=myPassword;Max Pool Size=40; Connection Timeout=60;Desactivar el POOLING
Data Source=myOracle;User Id=myUsername;Password=myPassword;Pooling=False;Usando autentificacion de windows
Data Source=myOracle;User Id=/;Coneccion con privilegios
Data Source=myOracle;User Id=myUsername;Password=myPassword;DBA Privilege=SYSDBA;Coneccion hacia un balance de carga
Data Source=myOracle;User Id=myUsername;Password=myPassword;Load Balancing=True;
http://www.youcode.com.ar/visual-basic-net/oracle-modos-de-coneccion-desde-visual-basic-net-315