Solucionado (ver solução)
Solucionado
(ver solução)
1
resposta

Conexão com Oracle

Olá! Em nossa empresa utilizamos o banco Oracle, como a como faço a conexão ?

Ao tentar executar o comando, é apresentada a falha abaixo.

2022-04-28 14:31:58.360977 ThreadID:1 (ERROR) OracleCompositeMemberTranslator.CreateDbConnection() : System.ArgumentException: 'server' é um atributo de string de conexão inválido at OracleInternal.ConnectionPool.ConnectionString.SetProperty(String key, String value, String quotedValue, String originalKey, SecureString secPasswd) at OracleInternal.ConnectionPool.ConnectionString.Parse(OracleConnection con, String constr) at OracleInternal.ConnectionPool.ConnectionString..ctor(OracleConnection con, String constring, OracleCredential credential) at OracleInternal.ConnectionPool.ConnectionString.GetCS(OracleConnection con, String constr, OracleCredential credential, Boolean bCreateIfNotinCache) at Oracle.ManagedDataAccess.Client.OracleConnection.setConnectionString(String value) at Oracle.ManagedDataAccess.Client.OracleConnection..ctor(String connectionString) at Oracle.EntityFrameworkCore.Storage.Internal.OracleRelationalConnection.CreateDbConnection()2022-04-28 14:31:58.360977 ThreadID:1 (ERROR) OracleCompositeMemberTranslator.CreateDbConnection() : System.ArgumentException: 'server' é um atributo de string de conexão inválido at OracleInternal.ConnectionPool.ConnectionString.SetProperty(String key, String value, String quotedValue, String originalKey, SecureString secPasswd) at OracleInternal.ConnectionPool.ConnectionString.Parse(OracleConnection con, String constr) at OracleInternal.ConnectionPool.ConnectionString..ctor(OracleConnection con, String constring, OracleCredential credential) at OracleInternal.ConnectionPool.ConnectionString.GetCS(OracleConnection con, String constr, OracleCredential credential, Boolean bCreateIfNotinCache) at Oracle.ManagedDataAccess.Client.OracleConnection.setConnectionString(String value) at Oracle.ManagedDataAccess.Client.OracleConnection..ctor(String connectionString) at Oracle.EntityFrameworkCore.Storage.Internal.OracleRelationalConnection.CreateDbConnection()**

1 resposta
solução!

Consegui fazer a conexão com a ConnectionString abaixo:

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

Encontrei no link :

https://www.connectionstrings.com/oracle/