How to set language for MS SQL Server OLEDB adapter
book
Article ID: KB0070096
calendar_today
Updated On:
Products
Versions
ibi WebFOCUS
8207.28 and above.
Description
How can one set the language of their choice for the text coming from the MS SQL Server OLE DB Adapter since MS SQL Server OLE DB doesn't have an option like NLS_LANG, where one can set the language for other adapters such as the Oracle adapter.
Environment
Windows, Linux
Resolution
As the MSSQL Server OLEDB adapter doesn't have an option like NLS_LANG, we have another way to achieve it. One can add 'Language=Spanish' in the field of 'Additional Connection string keywords (optional)', so that all the text coming from the same adapter will be translated into Spanish language.
To set the language as Spanish:
Navigate to the reporting server
Go to 'Get Data'
Double-click on 'MySQL Server OLEDB/AZURE DB Connections'
Right-click on the connection
Select 'Properties' you will see the field called 'Additional Connection String Keywords (optional)
Add LANGUAGE=spanish
Below is the screenshot for reference:
Issue/Introduction
How can one set the language of their choice for the text coming from the MS SQL Server OLE DB Adapter.