Microsoft OLE DB Provider for Microsoft Index Server

See Also   

The Microsoft OLE DB Provider for Microsoft Index Server provides programmatic read-only access to file system and Web data indexed by Microsoft® Index Server 2.0. ADO applications can issue SQL queries to retrieve content and file property information.

The provider is free-threaded and unicode enabled.

Connection String Parameters

To connect to this provider, set the Provider= argument to the ConnectionString property to:

MSIDXS

Reading the Provider property will return this string as well.

Command Text

The Index Server SQL query syntax consists of extensions to the SQL92 SELECT statement and its FROM and WHERE clauses. The results of the query are returned via OLE DB rowsets, which can be consumed by ADO and manipulated as Recordset objects.

You can search for exact words or phrases, or use wildcards to search for patterns or stems of words. The search logic can be based on Boolean decisions, weighted terms' proximity to other words. You can also search by "free text," which finds matches based on meaning, rather than exact words.

The specific command dialect is fully documented in the Microsoft Index Server Reference under "SQL Access to Index Server Data."

The provider does not accept stored procedure calls or simple table names (for example, the CommandType property will always be adCmdText).

Recordset Behavior

The following tables list the features available with a Recordset object opened with this provider. Only the Static cursor type (adOpenStatic) is available.

For more detailed information about Recordset behavior for your provider configuration, run the Supports method and enumerate the Properties collection of the Recordset to determine whether provider-specific dynamic properties are present.

Availability of standard ADO Recordset properties:

Property Availability
AbsolutePage read/write
AbsolutePosition read/write
ActiveConnection read-only
BOF read-only
Bookmark* read/write
CacheSize read/write
CursorLocation always adUseServer
CursorType always adOpenStatic
EditMode always adEditNone
EOF read-only
Filter read/write
LockType read/write
MarshalOptions not available
MaxRecords read/write
PageCount read-only
PageSize read/write
RecordCount read-only
Source read/write
State read-only
Status read-only

*Bookmarks must be enabled on the provider in order for this feature to exist on the Recordset.

Availability of standard ADO Recordset methods:

Method Available?
AddNew No
Cancel
CancelBatch No
CancelUpdate No
Clone Yes
Close Yes
Delete No
GetRows Yes
Move Yes
MoveFirst Yes
MoveLast Yes
MoveNext Yes
MovePrevious Yes
NextRecordset Yes
Open Yes
Requery Yes
Resync Yes
Supports Yes
Update No
UpdateBatch No

See Also   For specific implementation details and functional information about the Microsoft OLE DB Provider for Microsoft Index Server, consult the Microsoft OLE DB Programmer's Reference and the Microsoft Index Server documentation. The Microsoft Internet Information Server Web page at http://www.microsoft.com/iis also contains information about Microsoft Index Server.