asp.net连接oracle数据库问题
1.string strcon = "Data Source=219.246.178.124_orcl;uid=system;pwd=jichao";
OracleConnection oraclecon = new OracleConnection(strcon);
oraclecon.Open();
错误:tns:12154 无法解析指定的连接符
2.string strcon = "Data Source=orcl;uid=system;pwd=jichao";
OracleConnection oraclecon = new OracleConnection(strcon);
oraclecon.Open();
oraclecon.Close();
错误:tns:12154 无法解析指定的连接符
3.string strcon = "Data Source=219.246.178.124:1521_orcl;uid=system;pwd=jichao";
OracleConnection oraclecon = new OracleConnection(strcon);
oraclecon.Open();
oraclecon.Close();
错误:ora—06413:链接为打开
4.string strcon = "Data Source=219.246.178.124:1521/orcl;uid=system;pwd=jichao";
OracleConnection oraclecon = new OracleConnection(strcon);
oraclecon.Open();
oraclecon.Close();
错误:ora—06413:链接为打开求给位大神帮帮忙啊,不要嫌问题简单啊
1.string strcon = "Data Source=219.246.178.124_orcl;uid=system;pwd=jichao";
OracleConnection oraclecon = new OracleConnection(strcon);
oraclecon.Open();
错误:tns:12154 无法解析指定的连接符
2.string strcon = "Data Source=orcl;uid=system;pwd=jichao";
OracleConnection oraclecon = new OracleConnection(strcon);
oraclecon.Open();
oraclecon.Close();
错误:tns:12154 无法解析指定的连接符
3.string strcon = "Data Source=219.246.178.124:1521_orcl;uid=system;pwd=jichao";
OracleConnection oraclecon = new OracleConnection(strcon);
oraclecon.Open();
oraclecon.Close();
错误:ora—06413:链接为打开
4.string strcon = "Data Source=219.246.178.124:1521/orcl;uid=system;pwd=jichao";
OracleConnection oraclecon = new OracleConnection(strcon);
oraclecon.Open();
oraclecon.Close();
错误:ora—06413:链接为打开求给位大神帮帮忙啊,不要嫌问题简单啊
2.请安装PL/SQL客户端然后用PLSQL连接一下
3.在web中加入
<add key="ConnectionString" value="user id=sa;data source=data;password=aaa" />
然后用测试
protected static string connectionString = ConfigurationSettings.AppSettings["ConnectionString"];
public static int ExecuteSql(string SQLString)
{
using (OracleConnection connection = new OracleConnection(connectionString))
{
using (OracleCommand cmd = new OracleCommand(SQLString,connection))
{ try
{
try
{
connection.Open();
int rows=cmd.ExecuteNonQuery();
return rows;
}
catch(System.Data.OracleClient.OracleException E)
{
connection.Close();
throw new Exception(E.Message);
} }
catch
{
setconbak();
return 0;
}
}
} }
2:sqlplus连接是否正常
3:测试“本地.Net服务名配置”是否能连通
通过sqlplus / as sysdba看能否登录成功,如果成功说明应该是tnsnames.ora文件配置有问题
检查tnsnames.ora中的HOST,PORT,SERVICE_NAME
应当是 tnsnames.ora 的配置有问题你把这个文件检查一下
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
大神帮忙看看有什么问题
你需要在本地客户端里监听服务端