Microsoft KB Archive/324302

= PRB: You cannot pass the LCID to the MSIXDS Provider to specify the connection to the Indexing Service =

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:

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

Additional query words: connection string Index Server

Keywords: kbprb KB324302

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.