Oracle connection strings

Cadenas de conexión para vb.net

Mediante Servidor TNS

Data Source=(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=milenage))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)));User Id=myUsername;Password=myPassword;

Ejemplo de conexión:

Try
string oradb = “Data Source=(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=milenage))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)));User Id=myUsername;Password=myPassword;”;
conn.Open()
Dim conn As New OracleConnection(oradb)
OracleConnection conn = new OracleConnection(oradb);
End Try

Conectando en local a Oracle Database XE 11.2

data Source=127.0.0.1;User Id=myUsername;Password=myPassword;

 

Ver más en … https://www.connectionstrings.com/oracle/

Deja un comentario