我用PL/SQL DeveLoper 可以连接
用SQL Plus 也可以连接
但C#去连接的时候抱异常:
ORA-12154 : TNS 无法解析指定的连接标识符代码如下: private string Connection = "Data Source=MES;uid=emesc;pwd=EMESC;";
private OracleConnection _oc;
public void Connec()
{
try
{
_oc = new OracleConnection(Connection);
_oc.Open();
}
catch (OracleException oe)
{
MessageBox.Show(oe.ToString());
}
}
请问怎么回事?
用SQL Plus 也可以连接
但C#去连接的时候抱异常:
ORA-12154 : TNS 无法解析指定的连接标识符代码如下: private string Connection = "Data Source=MES;uid=emesc;pwd=EMESC;";
private OracleConnection _oc;
public void Connec()
{
try
{
_oc = new OracleConnection(Connection);
_oc.Open();
}
catch (OracleException oe)
{
MessageBox.Show(oe.ToString());
}
}
请问怎么回事?
如下格式:
MES =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = xxxx))
)
(CONNECT_DATA =
(SERVICE_NAME = MES)
(INSTANCE_NAME = MES)
)
)