tcp无法连接oracle,Reporting Services无法连接ORACLE，提示：System.Data.OracleClient 需要 Oracle 客户端软件 8.1.7 或更高版本...

Reporting Services无法连接ORACLE，在服务器安装ORACLE 11客户端版本后仍然提示以下错误：

System.Data.OracleClient 需要 Oracle 客户端软件 8.1.7 或更高版本

如图：

使用DOS命令是可以连接到ORACLE的

Micsoft用来连接oracle的odbc驱动

没有直接的odbc驱动，需要安装oracle客户端的，安装oracle客户端后，再用 Net Configuration Assistant 配置一个NET服务名

附加其它

连接字符串：

Data Source="(DESCRIPTION =  ADDRESS_LIST =

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

)

(CONNECT_DATA =

(SERVICE_NAME = SEINESCM)

)

)"

服务器监听文件：C:\app\Administrator\product\11.2.0\client_1\network\admin\tnsnames.ora

# tnsnames.ora Network Configuration File: C:\app\Administrator\product\11.2.0\client_1\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

SEINESCM_32 =

(DESCRIPTION =

(ADDRESS_LIST =

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

)

(CONNECT_DATA =

(SERVICE_NAME = SEINESCM)

)

)

SEINESCM =

(DESCRIPTION =

(ADDRESS_LIST =

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

)

(CONNECT_DATA =

(SERVICE_NAME = SEINESCM)

)

)

服务器监听文件：C:\app\Administrator\product\11.2.0\client_1\network\admin\listener.ora

# listener.ora Network Configuration File: C:\app\Administrator\product\11.2.0\client_1\network\admin\listener.ora

# Generated by Oracle configuration tools.

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = REPORTSERVER01.ninestar.local)(PORT = 1521))

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

)

ADR_BASE_LISTENER = C:\app\Administrator

原文：http://www.cnblogs.com/Snowfun/p/3879895.html