asp.net连接oarcle

[greatsj]

上网查，但还是连接不上，提示是 异常详细信息: System.Data.OracleClient.OracleException: ORA-12154: TNS: 无法解析指定的连接标识符

WEB.CONFIG配置
<add name="OracleConn" connectionString="Data Source=192.168.1.154;User ID=orlac;Password=123456;Unicode=True" providerName="System.Data.OracleClient"/>

public static readonly string connectionString = ConfigurationManager.ConnectionStrings["OracleConn"].ConnectionString;
protected void Page_Load(object sender, EventArgs e)
{
string sql="select * from mana.looks ";

OracleConnection conn = new OracleConnection(connectionString );
conn.Open();
try
{
OracleCommand com = new OracleCommand(sql,conn);
GridView1.DataSource= com.ExecuteReader();
GridView1.DataBind();
}
catch (Exception ee)
{
Response.Write(ee.Message); //如果有错误，输出错误信息
}

也在TOPTEST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.154)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = toptest)

)

怎么解决，求解

[Zeusro]

连接字符串出错了

[greatsj]

字符串出错，出错在哪

[save4me]

参考: asp.net to oracle application produces error ORA-12154 :TNS:could not resolve the connect identifier specified

引用

The solution for me was to simply add the ASPNET user to the accounts allowed to access the tnsnames.ora file: 1) Locate the tnsnames.ora file 2) Right click and select properties 3) Click Security and add the ASPNET user, make sure it has at least Read and Read & Execute permissions

打开 tnsnames.ora文件，给ASP.NET用户权限 或者参考: ASP.NET webapp - ORA-12154: TNS:could not resolve the connect identifier specified 用下面的连接字符串

"Data source=(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = replaced.host.name)(PORT = 1521))(CONNECT_DATA =(SID = rmsusnap)));User ID=uuuu;Password=pppp;"

[漫天雪飞]

很明显,连接字符串不正确. 百度一个正确的

[wangweimutou]

你有没有配置你的oracle客户端啊，先把你的oracle客户端驱动和服务端连接成功，其他的都不是问题啦