@ssrs2022
1 Topic
Report Server with Oracle ODP.Net Managed 19.21 Language Problem
Hi Pals, We are currently at SSRS 2022 pre-upgrade verify compatibility stage. While querying the Oracle E-Business Suite 11i (ERP 11i) database (Oracle 11.2.0.4 version), we are using the Oracle ODP.Net Managed Driver (ODPM) 19.21 version. Currently, we are encountering the following issues: The Oracle ERP database supports multi-language configurations. In previous versions of ODP.Net, the NLS_LANG setting referred to the Windows Registry However, the ODP.Net Managed Driver does not support using NLS_LANG. During testing, we discovered the following problems with SSRS + ODPM 19.21: The USERENV('LANG') result from the database keep change between ZHT and US ( Language ) Setting the Language Property of the Paginated Report to en-US does not work with ODPM, meaning that the report language is not passed to ODPM. Regards, Wilson Shen Senior Microsoft BI EngineerSolved2KViews0likes4Comments