Page 1 of 1

current language MSSQL

Posted: Sat 04 Aug 2012 10:36
by Tomasz Andrzejewski
Hi,

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

Re: current language MSSQL

Posted: Mon 06 Aug 2012 08:15
by 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?

Re: current language MSSQL

Posted: Mon 06 Aug 2012 08:59
by 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.

Re: current language MSSQL

Posted: Mon 06 Aug 2012 09:13
by Tomasz Andrzejewski
UniConnection.SpecificOptions.Values['Language'] := 'polski';

Works.

Re: current language MSSQL

Posted: Mon 06 Aug 2012 11:07
by AndreyZ
Feel free to contact us if you have any other questions about UniDAC.