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

Question

(From my research, Index Server no longer exists on Win2012 -- If this is mistaken, tell me how to set it up!)

Moving a nice .asp application from Win2003 server to Win2012. This app makes heavy use of Index Server via the OLE DB driver for index server.

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 do I do this against Microsoft Search Service?

Is there an OLE DB provider for Search Service?
If not, what is the appro way to access Search Service from VBA/ASP/Python?

score 3 · Answer 1 · edited Jun 10 '16 at 08:02

3

use Provider=Search.CollatorDSO;Extended Properties='Application=Windows'; as connectionstring.

edited Jun 10 '16 at 08:02

Kiquenet

14,494
35
148
243

answered May 10 '14 at 08:04

Glenn

31
1

And how do you handle "The 'Search.CollatorDSO' provider is not registered on the local machine." as seen in exception posted here: http://pastebin.com/sEVSRSit – Jonesome Reinstate Monica May 19 '14 at 14:55

score 3 · Accepted Answer · edited Aug 08 '16 at 08:00

3

After lots of digging around, the answer has been found.

Downloading and installing Windows Search Server does not install the OLE DB provider. Neither does installing the Windows SDK. The provider is installed when the Windows Search Service is installed.

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

enter image description here

edited Aug 08 '16 at 08:00

Uwe Keim

39,551
56
175
291

answered May 19 '14 at 16:13

Jonesome Reinstate Monica

6,618
11
65
112

***Microsoft OLE DB Provider for Microsoft Indexing Service*** is _MSIDXS_ . **Windows Search Server is the same Microsoft Indexing Service?** – Kiquenet Jun 10 '16 at 08:04

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

2 Answers2

Linked