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
Reporting Services无法连接ORACLE,提示:System.Data.OracleClient 需要 Oracle 客户端软件 8.1.7 或更高版本,布布扣,bubuko.com
Reporting Services无法连接ORACLE,提示:System.Data.OracleClient 需要 Oracle 客户端软件 8.1.7 或更高版本