Reporting services cannot connect to Oracle, Tip: System.Data.OracleClient requires Oracle client software 8.1.7 or later

Reporting services cannot connect to Oracle, and the following error is still indicated after the server installs the Oracle 11 client version:

System.Data.OracleClient requires Oracle client software 8.1.7 or later

A DOS command is used to connect to Oracle's

Micsoft ODBC Driver for connecting to Oracle

There is no direct ODBC driver, you need to install the Oracle client, after installing the Oracle client, then use NET configuration Assistant to configure a net service name

Attach Other

even Connection string :

Data source= "(DESCRIPTION = Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 10.10.1.116) (PORT = 1521))
)
(Connect_data =
(service_name = SEINESCM)
)
)"

Server listener files: 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)
)
)

Server Listener file: 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