How to set language for MS SQL Server OLEDB adapter

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.

 

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:
  1. Navigate to the reporting server
  2. Go to 'Get Data'
  3. Double-click on 'MySQL Server OLEDB/AZURE DB Connections'
  4. Right-click on the connection
  5. Select 'Properties' you will see the field called 'Additional Connection String Keywords (optional)
  6. Add LANGUAGE=spanish

Below is the screenshot for reference:
User-added image