ADO: Supported Methods and Properties

The following table identifies which methods and properties of ADO objects are supported and which are not supported by the SAS providers.

Note: The SAS providers do not support the ICommandWithParameters interface, so the Parameter object and Parameter collection are not supported and are not included in the table.

^* MDX queries with the OLAP provider can be cancelled if the query is made asynchronously with the Execute method.

	SUPPORTED		UNSUPPORTED
ADO Object	Methods	Properties	Methods	Properties
Connection	Close ConnectionString Open Execute OpenSchema	Attributes CursorLocation Mode Provider State	BeginTrans Cancel ^* CommitTrans RollbackTrans	CommandTimeout ConnectionTimeout DefaultDatabase IsolationLevel
Command	Execute	ActiveConnection CommandText CommandType Name Prepared State	Cancel ^* CreateParameter	CommandTimeout
Recordset	AddNew CacheSize CancelBatch CancelUpdate Close Clone Delete Find GetRows GetString Move MoveFirst MoveLast MoveNext MovePrevious Open Requery Save Supports Update UpdateBatch	AbsolutePage AbsolutePosition BOF Bookmark CursorLocation CursorType Data Source EditMode EOF Filter LockType MaxRecords PageCount PageSize RecordCount Sort State	Cancel CompareBookmarks NextRecordset Resync Seek	ActiveCommand DataMember Index MarshalOptions Status StayInSync Source
Error		Description Number Source		HelpContext HelpFile NativeError SQLState
Errors Collection	Clear Refresh	Count Item
Field		ActualSize Attributes DefinedSize Name NumericScale Precision Type Value	AppendChunk GetChunk	DataFormat OriginalValue UnderlyingValue
Fields Collection	Append Refresh	Count Item	Delete
Property		Attributes Name Type Value
Properties Collection	Refresh	Count Item