SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,320 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
class ConnectOracle
{
private static string strCon = @"Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=pda_test))); User Id = dlit; Password = dlit12345;";
private OracleConnection conn;
public void ConnectionOracle()
{
try
{
if (conn == null)
{
conn = new OracleConnection(strCon);
}
conn.Open();
}
catch (Exception e)
{
Console.WriteLine("Error : The Database Connection is failed..." + e.Message);
}
}
이렇게 연결을 하였는대
network transport tcp transport address connect failure oracle
오류가나요.
하지만 방화벽설정
lsnrctl services 등록 모두하였습니다.