How Can I Change “Language� Setting Using “Locale Identifier� Of DBPromptInitialize Dialog?

Hi,

I use pIDBPromptInitialize interface for establish a connection to MS SQL Server 2005.
SQL Server has €œus_english€? (LCID=1033) language as default setting.

I use the following part of code to charge LCID (from 1033 to 1049):

CDBPropSet ps3;
ps3.SetGUID(DBPROPSET_DBINIT );
ps3.AddProperty(DBPROP_INIT_LCID, (long)1049);
hr= pIDBProperties->SetProperties(1, &ps3);

hr= pIDBPromptInitialize->PromptDataSource(NULL, GetActiveWindow(),
DBPROMPTOPTIONS_PROPERTYSHEET,
0, NULL, (LPOLESTR)szFilter,
IID_IDBProperties, (IUnknown **)(&pIDBProperties));
...
hr = FDS->Connection->m_spInit->Initialize();

Then I connect to SQL Server successfully.

But SQL Server has LCID=1033 anyway!! Way I didn€™t change it by my code? What is wrong?


But later I try to use some feature of LCID=1049 (date conversation)


How can I change €œLanguage€? setting to, for example, Russian (LCID=1049) using pIDBPromptInitialize
G.