OLE DB Provider for Internet Publishing Command Object

The following interfaces of the Command object are supported by the current version of the OLE DB Provider for Internet Publishing. For the default OLE DB behavior of these interfaces see the OLE DB 2.5 programmers reference:

  • IAccessor
  • IColumnsInfo
  • ICommand
  • ICommandProperties
  • ICommandText
    • When the command is first created, it does not contain command text. The consumer sets the command text with ICommandText::SetCommandText. Because the text command syntax is provider-specific, the consumer passes the GUID of the syntax to use. The allowed values are DBGUID_DEFAULT or DBGUID_DBSQL.
    • Please note that the OLE DB Provider for Internet Publishing cannot determine the level of SQL support of the underlying data provider. It sets the value of DBPROP_SQLSUPPORT to DBPROPVAL_SQL_NONE signifying that SQL is not supported. In spite of this value the data provider may support SQL. The only way to determine the level of SQL support is by executing SQL commands and watching for error messages.
    • The command text is case sensitive regardless of the data source.
  • IConnectionPointContainer
  • IConvertType
  • IDBAsynchStatus
  • IDBInitialize
  • ISupportErrorInfo

Command dialects DBGUID_DEFAULT and DBGUID_DBSQL are passed by the OLE DB Provider for Internet Publishing to the FrontPage and WebDAV protocols (the OLE DB Provider does not do any processing of SQL commands itself). When using the OLE DB Provider for Internet Publishing with a WebDAV server which supports SQL commands, these command dialects may be used to retrieve rowsets. If the Web server does not support SQL commands, the OLE DB Provider for Internet Publishing will return an error.