Querying Physical Directories in Index Server Using SQL Returns Empty Recordsets

ID: Q249224

The information in this article applies to:

Microsoft Index Server version 2.0

SUMMARY

Querying physical directories in an Index Server using the OLEDB Provider MSIDX returns empty recordsets, because the default Scope only includes all virtual directories.

MORE INFORMATION

If you are using physical and virtual directories in a catalog, you need to set the appropriate Scope in the SQL Statement.

By default an empty argument in Scope() is interpreted as "/", so that all virtual directories are in Scope.

To include all virtual and physical directories in the Scope, the Select statement should look like the following:


Select Column from Scope('"/","\"')

Here is a sample, how to code this statement in Visual Basic script:


SelectString = "Select Column from Scope('" + chr(34) + "/" + chr(34) + "," + chr(34) + "\" + chr(34) + "')"

Additional query words: MSIDX scope OLEDB directory SQL

Keywords :
Version : winnt:2.0
Platform : winnt
Issue type : kbinfo