How to set language for MS SQL Server OLEDB adapter
Article ID: KB0070096
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.
Issue/Introduction
How can one set the language of their choice for the text coming from the MS SQL Server OLE DB 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:
Below is the screenshot for reference:
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:
Feedback
Yes
No
Powered by
