Contents
| | |
|
Microsoft OLE DB Provider for Microsoft Index Server
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. Microsoft Index Server and its OLE DB provider are included in the Microsoft Windows NT 4.0 Option Pack.
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
MSIDXSReading the Provider property will return this string as well.
Command Text
The Index Server SQL query syntax consists of extensions to the SQL-92 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 find 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 on 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:
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:
AddNew No 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
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 "Microsoft Index Server" documentation, or visit the Microsoft Index Server Web page.
Top of Page
© 1997 Microsoft Corporation. All rights reserved. Terms of Use.