Forum Discussion
Report Server with Oracle ODP.Net Managed 19.21 Language Problem
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.pdfHowever, 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
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.
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
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