OracleConnection oledbCon = new OracleConnection("Data Source = zghouseDB; User Id = scott; Password = oracle; Integrated Security = no;");
if (oledbCon.State == ConnectionState.Closed)
{
oledbCon.Open();
if (oledbCon == null)
{
MessageBox.Show("odbc数据库连接失败", "系统提示");
}
}
return oledbCon;在执行oledbCon.Open();这句的时候报错,类型为:ORA-12154: TNS: 无法解析指定的连接标识符
请帮帮忙!
if (oledbCon.State == ConnectionState.Closed)
{
oledbCon.Open();
if (oledbCon == null)
{
MessageBox.Show("odbc数据库连接失败", "系统提示");
}
}
return oledbCon;在执行oledbCon.Open();这句的时候报错,类型为:ORA-12154: TNS: 无法解析指定的连接标识符
请帮帮忙!
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\oracle\product\10.1.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = PC-200908201515)(PORT = 1521))
)
)
)这里里面的内容,怎末检查啊
数据库服务器上的监听是否启动,使用LSNRCTL START来启动。
还有就是看看本地客户端在配置服务的时候使用的通信协议,看你的配置应该选在TCP/IP(Internat协议)