PRB: You cannot pass the LCID to the MSIXDS Provider to specify the connection to the Indexing Service (324302)

SYMPTOMS

When you configure a linked server in Microsoft SQL Server, you cannot pass the locale identifier (LCID) to the MSIXDS Provider to specify in the connection to the Indexing Service. The LCID is used to determine the language resources that are required to index and query documents in different languages. Therefore, Indexing Service queries can only use English language settings when you use a distributed query in SQL Server.

CAUSE

Currently, the MSIXDS Provider does not support the DBPROP_INIT_PROVIDERSTRING OLE DB property. The DBPROP_INIT_PROVIDERSTRING OLE DB property is required to support the Provider String parameter when you configure a linked server in SQL Server. The Provider String parameter contains connection string information that is specific to the OLE DB provider.

For a list of OLE DB properties that are supported by the MSIXDS Provider, visit the following MSDN Web site:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/indexsrv/html/ixoledb_7msz.asp

MORE INFORMATION

A linked server that uses the MSIXDS Provider is successfully created when you specify a value for the Provider String parameter with the sp_addlinkedserver system stored procedure. However, the value of the Provider String parameter is ignored by the MSIXDS provider.

When you use SQL Server Enterprise Manager to create a linked server that uses the MSIXDS provider, the Provider String parameter is not available. For additional information about how Microsoft Indexing Service uses the LCID, click the following article number to view the article in the Microsoft Knowledge Base:

252868 How Index Server determines query and indexing languages