topic Re: Report Server with Oracle ODP.Net Managed 19.21 Language Problem in Report Server

Report Server with Oracle ODP.Net Managed 19.21 Language Problem

WlisonShen — Tue, 19 Nov 2024 05:25:05 GMT

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 Engineer

Re: Report Server with Oracle ODP.Net Managed 19.21 Language Problem

Anonymous — Wed, 20 Nov 2024 06:26:55 GMT

Hi, WlisonShen

Do you have documentation to check the settings of Oracle, such as:

Configuring Oracle Data Provider for .NET

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Report Server with Oracle ODP.Net Managed 19.21 Language Problem

WlisonShen — Wed, 20 Nov 2024 07:05:31 GMT

Hi Jianpeng Li,

Thank you for your kind support.

We are following the Oracle document provided here:
https://www.oracle.com/a/ocom/docs/database/adw-connect-sql-server-rpt-services.pdf

However, there is no mention of any LANGUAGE specification in the document.

Are you suggesting that we can specify the language via the .NET machine.config file?

Regards,
Wilson

Re: Report Server with Oracle ODP.Net Managed 19.21 Language Problem

WlisonShen — Wed, 20 Nov 2024 07:07:15 GMT

Hi Jianpeng Li,

Thank you for your kind support.

We are following the Oracle document provided here:
https://www.oracle.com/a/ocom/docs/database/adw-connect-sql-server-rpt-services.pdf.

However, there is no mention of any LANGUAGE specification in the document.

Are you suggesting that we can specify the language via the .NET machine.config file?

Regards,
Wilson

Re: Report Server with Oracle ODP.Net Managed 19.21 Language Problem

WlisonShen — Fri, 24 Jan 2025 03:27:52 GMT

Hi All,

Update final status.

According Microsoft Support Engineer said. SSRS 2022 + Oracle ODP.Net Managed not assocaiated with Oracle session NLS variable ： select userenv('LANG') from dual

We had to using ：alert session modify NLS_Language / NLS_Territory / NLS_DateFormat solution to force NLS_LANGUAGE to US format.

Regards,

Wilson