public frmInfoBanco(string p_Usuario, string p_Senha, string p_Database) { InitializeComponent(); csOracle _csOracle = new csOracle(); string _Mensagem = ""; string _Consulta = ""; _Consulta = _Consulta + "SELECT 'SERVER_HOST' AS NOME, UPPER(SYS_CONTEXT('USERENV', 'SERVER_HOST')) AS VALOR FROM DUAL UNION ALL "; _Consulta = _Consulta + "SELECT 'IP_ADRESS', UTL_INADDR.GET_HOST_ADDRESS FROM DUAL UNION ALL "; _Consulta = _Consulta + "SELECT 'INSTANCE_NAME' AS NOME, UPPER(INSTANCE_NAME) AS VALOR FROM V$INSTANCE UNION ALL "; _Consulta = _Consulta + "SELECT 'DB_NAME', SYS_CONTEXT('USERENV', 'DB_NAME') FROM DUAL UNION ALL "; _Consulta = _Consulta + "SELECT 'TNSNAMES_ALIAS', '" + p_Database + "' FROM DUAL UNION ALL "; _Consulta = _Consulta + "SELECT 'ULTIMO_RESTORE' AS NOME, TO_CHAR(MAX(RESETLOGS_TIME), 'DD/MM/YYYY HH24:MI:SS') FROM GV$DATABASE_INCARNATION UNION ALL "; _Consulta = _Consulta + "SELECT 'AUTHENTICATED_IDENTITY', SYS_CONTEXT('USERENV', 'AUTHENTICATED_IDENTITY') FROM DUAL UNION ALL "; _Consulta = _Consulta + "SELECT 'AUTHENTICATION_METHOD', SYS_CONTEXT('USERENV', 'AUTHENTICATION_METHOD') FROM DUAL UNION ALL "; _Consulta = _Consulta + "SELECT 'AUTHENTICATION_TYPE', SYS_CONTEXT('USERENV', 'AUTHENTICATION_TYPE') FROM DUAL UNION ALL "; _Consulta = _Consulta + "SELECT 'CURRENT_SCHEMA', SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL UNION ALL "; _Consulta = _Consulta + "SELECT 'CURRENT_SCHEMAID', SYS_CONTEXT('USERENV', 'CURRENT_SCHEMAID') FROM DUAL UNION ALL "; _Consulta = _Consulta + "SELECT 'CURRENT_USER', SYS_CONTEXT('USERENV', 'CURRENT_USER') FROM DUAL UNION ALL "; _Consulta = _Consulta + "SELECT 'CURRENT_USERID', SYS_CONTEXT('USERENV', 'CURRENT_USERID') FROM DUAL UNION ALL "; _Consulta = _Consulta + "SELECT 'LOCAL_HOST', SYS_CONTEXT('USERENV', 'HOST') FROM DUAL UNION ALL "; _Consulta = _Consulta + "SELECT 'LOCAL_USER', SYS_CONTEXT('USERENV', 'OS_USER') FROM DUAL UNION ALL "; _Consulta = _Consulta + "SELECT 'ISDBA', SYS_CONTEXT('USERENV', 'ISDBA') FROM DUAL UNION ALL "; _Consulta = _Consulta + "SELECT 'LANG', SYS_CONTEXT('USERENV', 'LANG') FROM DUAL UNION ALL "; _Consulta = _Consulta + "SELECT 'LANGUAGE', SYS_CONTEXT('USERENV', 'LANGUAGE') FROM DUAL UNION ALL "; _Consulta = _Consulta + "SELECT 'MODULE', SYS_CONTEXT('USERENV', 'MODULE') FROM DUAL UNION ALL "; _Consulta = _Consulta + "SELECT 'NETWORK_PROTOCOL', SYS_CONTEXT('USERENV', 'NETWORK_PROTOCOL') FROM DUAL UNION ALL "; _Consulta = _Consulta + "SELECT 'NLS_CALENDAR', SYS_CONTEXT('USERENV', 'NLS_CALENDAR') FROM DUAL UNION ALL "; _Consulta = _Consulta + "SELECT 'NLS_CURRENCY', SYS_CONTEXT('USERENV', 'NLS_CURRENCY') FROM DUAL UNION ALL "; _Consulta = _Consulta + "SELECT 'NLS_DATE_FORMAT', SYS_CONTEXT('USERENV', 'NLS_DATE_FORMAT') FROM DUAL UNION ALL "; _Consulta = _Consulta + "SELECT 'NLS_DATE_LANGUAGE', SYS_CONTEXT('USERENV', 'NLS_DATE_LANGUAGE') FROM DUAL UNION ALL "; _Consulta = _Consulta + "SELECT 'NLS_SORT', SYS_CONTEXT('USERENV', 'NLS_SORT') FROM DUAL UNION ALL "; _Consulta = _Consulta + "SELECT 'NLS_TERRITORY', SYS_CONTEXT('USERENV', 'NLS_TERRITORY') FROM DUAL UNION ALL "; _Consulta = _Consulta + "SELECT 'SESSION_USER', SYS_CONTEXT('USERENV', 'SESSION_USER') FROM DUAL UNION ALL "; _Consulta = _Consulta + "SELECT 'SID', SYS_CONTEXT('USERENV', 'SID') FROM DUAL "; _csOracle.PreencheLvw(p_Usuario, p_Senha, p_Database, _Consulta, false, ref _Mensagem, ref lvwInfoBanco); this.ShowDialog(); }
private void btOK_Click(object sender, EventArgs e) { if (_TestarConexao) { if (_csOracle.ConectouNoBanco(txtUsername.Text, txtPassword.Text, cboDatabase.Text)) { _Usuario = txtUsername.Text; _Senha = txtPassword.Text; _Database = cboDatabase.Text; _csOracle = null; if (chkSalvar.Checked) { this.SalvaDadosConexao(_Usuario, _Senha, _Database); } else { this.SalvaDadosConexao(_Usuario, "", _Database); } this.Hide(); } } else { _Usuario = txtUsername.Text; _Senha = txtPassword.Text; _Database = cboDatabase.Text; _csOracle = null; if (chkSalvar.Checked) { this.SalvaDadosConexao(_Usuario, _Senha, _Database); } else { this.SalvaDadosConexao(_Usuario, "", _Database); } this.Hide(); } }