Reporting Services無法串連ORACLE，提示：System.Data.OracleClient 需要 Oracle 用戶端軟體 8.1.7 或更高版本

標籤：des   style   blog   http   color   使用   os   strong   

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