我用的win7 64位系统 ,现在oracle是10g32位的,plsql能连上,但是我程序里老连不上,老报那个ora-12154:tns:无法解析指定的连接标识符\n
tnsnames如下:# tnsnames.ora Network Configuration File: c:\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ARSDB_TAF =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.24.252.9)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.24.252.10)(PORT = 1521))
(LOAD_BALANCE = yes)
(FAILOVER=on)
(CONNECT_DATA=
(SERVER = DEDICATED)
(SERVICE_NAME = arsdb)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = basic)
)
)
)TFDB_TAF(58) =
(DESCRIPTION=
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.24.252.58)(PORT = 1521))
(LOAD_BALANCE = no)
(FAILOVER=on)
(CONNECT_DATA=
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = basic)
)
)
)MASDB_TAF =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.24.252.9)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.24.252.10)(PORT = 1521))
(LOAD_BALANCE = yes)
(FAILOVER=on)
(CONNECT_DATA=
(SERVER = DEDICATED)
(SERVICE_NAME = masdb)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = basic)
)
)
)
数据库连接字符:
<add name="SUPDB" connectionString="Data Source=ARSDB_TAF;Persist Security Info=True;User ID=dmzuser;Password=dmzuser" providerName="System.Data.OracleClient"/>求救啊!困惑的我都想换系统了,但是机器型号问题还不能换xp
tnsnames如下:# tnsnames.ora Network Configuration File: c:\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ARSDB_TAF =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.24.252.9)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.24.252.10)(PORT = 1521))
(LOAD_BALANCE = yes)
(FAILOVER=on)
(CONNECT_DATA=
(SERVER = DEDICATED)
(SERVICE_NAME = arsdb)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = basic)
)
)
)TFDB_TAF(58) =
(DESCRIPTION=
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.24.252.58)(PORT = 1521))
(LOAD_BALANCE = no)
(FAILOVER=on)
(CONNECT_DATA=
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = basic)
)
)
)MASDB_TAF =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.24.252.9)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.24.252.10)(PORT = 1521))
(LOAD_BALANCE = yes)
(FAILOVER=on)
(CONNECT_DATA=
(SERVER = DEDICATED)
(SERVICE_NAME = masdb)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = basic)
)
)
)
数据库连接字符:
<add name="SUPDB" connectionString="Data Source=ARSDB_TAF;Persist Security Info=True;User ID=dmzuser;Password=dmzuser" providerName="System.Data.OracleClient"/>求救啊!困惑的我都想换系统了,但是机器型号问题还不能换xp
解决方案 »
- 如何获取两个文件夹的 相对路径?
- 急 DataGridViewCheckBoxColumn问题??
- C#和C++结构体对应问题
- (最近大家都在找的东东,详细介绍)c# 程序文件安装备和打包
- datagrid怎么没有对列操作的属性?
- [HELP]关于线程池的一些困惑,望各位高手帮忙解惑![HELP]
- static变量问题
- 解决即送50分,十分满意就再加50分,各位请进来看看!~
- 如何在C#代码中实现在Sqlserver2000中添加用户???以及附加数据库???
- 请问C#程序可以在没有安装.NET Framework的电脑上运行吗?
- 关于c#中DataTable的Select过滤
- vs2008 水晶报表打印 如何设置打印高度,达到打印高度后换纸
并且配置ORACLE_HOME环境变量
这样一般来说就没问题了