Article ID: 324302
Article Last Modified on 10/29/2004
APPLIES TO
- Microsoft SQL Server 2000 Standard Edition
- Microsoft SQL Server 7.0 Standard Edition
This article was previously published under Q324302
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:
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
Additional query words: connection string Index Server
Keywords: kbprb KB324302
