ORA-12154:TNS:无法解析指定的连接标识符 [英] ORA-12154: TNS: Could not resolve the connection identifier specified
问题描述
我想创建一个asp.net C#应用程序,其中数据库是Oracle Express 10g。
现在我无法在visual studio 2010中与oracle建立连接。我正面临一个问题
ORA-12154:TNS:无法解析指定的连接标识符
我的连接string:
I want to make an asp.net C# application where database is Oracle Express 10g.
Now I cant make a connection with oracle in visual studio 2010. I am facing a problem
ORA-12154: TNS: Could not resolve the connection identifier specified
My connection string:
<add name="ConStr2" connectionString="Data Source=Rashed ;User ID=TestDB;Password=sa123" providerName="System.Data.OracleClient"/>
Windows
Windows:7
64位操作系统
数据库版本:
Oracle数据库10g快捷版10.2.0.1.0版 - 产品
PL / SQL版本10.2.0.1.0 - 生产
CORE 10.2.0.1.0生产
32位Windows的TNS:版本10.2.0.1.0 - 生产
NLSRTL版本10.2.0.1。 0 - 生产
TNS
Windows
Windows:7
64-bit Operating System
Database Version:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
TNS
XE=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=Rashed)
(PORT=1521)
)
(CONNECT_DATA=
(SERVER=dedicated)
(SERVICE_NAME=XE)
)
)
注意:我的oracle db正在运行。我正在使用visual studio 2010
谢谢
Rashed
NB: My oracle db is running. I am using visual studio 2010
Thanks
Rashed
推荐答案
< a href =http://docs.oracle.com/cd/B28359_01/appdev.111/b28844/using_aspnt.htm#BABJCDHG> http://docs.oracle.com/cd/B28359_01/appdev.111/b28844 /using_aspnt.htm#BABJCDHG [ ^ ]
http: //docs.oracle.com/cd/B28359_01/appdev.111/b28844/using_aspnt.htm [ ^ ]
http://bytes.com/topic/asp-net/answers/333208-how-connect-asp-net-oracle-database [ ^ ]
http://docs.oracle.com/cd/B28359_01/appdev.111/b28844/using_aspnt.htm#BABJCDHG[^]
http://docs.oracle.com/cd/B28359_01/appdev.111/b28844/using_aspnt.htm[^]
http://bytes.com/topic/asp-net/answers/333208-how-connect-asp-net-oracle-database[^]
这篇关于ORA-12154:TNS:无法解析指定的连接标识符的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!