current language MSSQL

[Tomasz Andrzejewski]

Hi,

How to set connect string property [Current Language=polski;] using UniDac?
I am using lates 2012 MSSQL Server.

[Tomasz Andrzejewski]

Is it possible? It is normal property of MSSQL connection string.
I've tried to pass this value via SpecificOptions with no efect.
[SELECT @@Language] returns default database language (in my configuration us_english).
Any ideas?

[AndreyZ]

Hello,

To set the SQL Server language name, you should set the Language SQL Server specific option. Here is a code example:

Code: Select all

UniConnection.SpecificOptions.Values['Language'] := 'polski';
UniConnection.Open;

For more information, please refer to the "UniDAC and SQL Server" article in the UniDAC documentation.

[Tomasz Andrzejewski]

UniConnection.SpecificOptions.Values['Language'] := 'polski';

Works.

[AndreyZ]

Feel free to contact us if you have any other questions about UniDAC.