All geek questions in one place

Microsoft Search Service: Is there an OLE DB Provider? (alternate: Index Server on Win2012?)

(From my research, Index Server no longer exists on Win2012 - If this is a mistake, tell me how to configure it!)

Moving a good .asp application from a Win2003 server to Win2012. This application makes heavy use of the index server using the OLE DB driver for the index server.

An example of how we use it:

StrSQL="SELECT size, doctitle, vpath, filename, size, write, " & _ "characterization, path, rank FROM SCOPE() " & _ "WHERE CONTAINS('"searching words"') " & _ "AND vPath LIKE '%Knowledgestore%'" " & _ "AND (filename like '%TXT')" & _ "ORDER BY rank DESC" Set ixQuery = Server.CreateObject("ADODB.Connection") Set QueryRS = Server.CreateObject("ADODB.RecordSet") ixQuery.Open "provider=msidxs;Data Source=knowledgestore" QueryRS.Open strSQL,ixQuery

How to do this for Microsoft search service?

  • Is there an OLE DB provider for the search service?
  • If not, how can I access the search service from VBA / ASP / Python?
0
source share
2 answers

After multiple searches, the answer was found.

Downloading and installing Windows Search Server does not install the OLE DB provider. Also, the Windows SDK is not installed. The provider is installed when the Windows Search service is installed.

On Win7 / 8, this is installed by default (I believe). On the server, you must enable this feature.

enter image description here

+3
source

use Provider=Search.CollatorDSO;Extended Properties='Application=Windows'; as a connection string.

+3
source

Source: https://habr.com/ru/post/1483120/

More articles:


All Articles