CODEWITHSUNDEEP
sql-serverdatabasewindowsfilesystemsodbc
Delecron
Delecron

Reputation: 119

Search Windows Indexing Service through SQL

This is more of a "just wondering" question. Is there any way to access the Windows Indexing service database through ODBC in MS Access or SQL Server? I know there are a million recursive programming ways to traverse the file system but if I was only looking for files with a certain name I would think something as simple as "Select Fullpath from CDrive Where FileName like '%HEVC%'" would be easier and more lightweight than other methods.

I can't seem to Google this since all it does is return a million results for ODBC DSN creation.

Upvotes: 0

Views: 1192

Answers (2)

Delecron
Delecron

Reputation: 119

Actually, Found something else here:

Querying the Index with Windows Search SQL Syntax

Works like a charm, just have to get used to the special SQL syntax. Works on Windows 10, just having a problem querying a Storage Space. I'll update if I find an answer.

Upvotes: 0

clifton_h
clifton_h

Reputation: 1298

Foreword: My focus is on other projects, but this is an interesting topic.

Microsoft uses an EDB file to provide a central Indexing Service - MSDN. Based on the Microsoft SQL Server CE engine, it is lightweight offers a number of methods for access including addition of third party file type definitions.

However, there are differences...significant ones that prevent direct translations of EDB and CEDB. Comparing EDB with SQL Server CE

As I said, there are access methods. The ODBC you were hoping for was discontinued after Windows XP.

However, Microsoft has developed two methods:

Both methods allow for quick file searches and likely could be integrated into whatever warehouse architecture you have through APIs, for example. However, there are limitations on methods that the links point out.

I admit I cannot give a full answer since I was learning, too, but hopefully this can point you in the right direction.

Cheers,

Upvotes: 1

Related Questions