连接oracle问题

[zzmsyt]

我用的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

[zzmsyt]

到底什么原因 啊 ，大牛指点下

[yanran_hill]

在win7上安装oracle clientX86
并且配置ORACLE_HOME环境变量

[zzmsyt]

我试着装了个64的oracle 但是plsql又连不上了 我都疯了

[yanran_hill]

如果是安装了64位的oracle server,那么最好在安装完Oracle Server以后,接着安装oracle client 32,
这样一般来说就没问题了