Developer Reference : Data Access Methods : OLE DB Provider Guide : Zen OLE DB Provider Implementation
 
Zen OLE DB Provider Implementation
Reference of Supported Properties, Methods, and Events
The following topics provide reference material for implementing Zen OLE DB Provider:
OLE DB Provider Implementation Reference
ADOX Implementation Reference
Visual Studio.NET Implementation Reference
OLE DB Provider Implementation Reference
This topic lists specifics for the Zen implementation of the OLE DB Provider.
Note No Asynchronous operations are supported.
Command
Methods
Supported
CreateParameter
Execute
Unsupported
Cancel
Properties
Supported
ActiveConnection
CommandText
CommandType
Name
Parameters
Prepared
Properties
State
Connection
Methods
Supported
BeginTrans (including nested transactions)
Close
CommitTrans
Execute
Open
adConnectUnspecified
OpenSchema
RollbackTrans
Unsupported
Cancel
Properties
Supported
Attributes
ConnectionString
CursorLocation
adUseClient, based on Microsoft Cursor Service
Errors
IsolationLevels
adXactRepeatableRead and adXactSerializable
Mode
adModeReadWrite
Properties
Provider
Version
Unsupported
CommandTimeout
ConnectionTimeout
DefaultDatabase
Events
Supported
CommitTransComplete
ConnectComplete
Disconnect
ExecuteComplete
EndOfRecordset
FieldChangeComplete
MoveComplete
RollbackTransComplete
WillExecute
WillChangeField
WillConnect
WillMove
Unsupported
InfoMessage
Field
Methods
Supported
AppendChunk
GetChunk
Properties
Supported
ActualSize
Gives the size held in the database
Accurate only to 65 KB on LongVarBinary and LongVarChar, after which the length can be found only using GetChunk
Attributes
DataFormat
DefinedSize
Name
NumericScale
OriginalValue
Precision
Properties
Status
Type
Value
Unsupported
UnderlyingValue
Fields
Methods
Unsupported
Append
CancelUpdate
Delete
Refresh
Resynch
Update
Properties
Supported
Count
Item
Parameter
Methods
Supported
AppendChunk
Properties
Supported
Attributes
Direction
Name
NumericScale
Precision
Properties
Size
Type
Value
Record
Not Supported
Recordset
Methods
Supported
AddNew
Cancel
CancelBatch
CancelUpdate
Clone
Close
CompareBookmark
Delete
Find
GetRows
GetString
Move
MoveFirst
MoveLast
MoveNext
MovePrevious
Open
Resync
Save
Seek
supported when using adCmdTableDirect
Supports
Update
UpdateBatch
Unsupported
Requery
Properties
Supported
AbsolutePage
AbsolutePosition
ActiveCommand
ActiveConnection
BOF
Bookmark
CacheSize
CursorLocation
CursorType
adOpenStatic, adOpenDynamic, and adOpenForwardOnly
DataSource
EditMode
EOF
Fields
Filter
Do not support views
Index
With adCmdTableDirect
LockType
adLockOptimistic, adLockBatchOptimistic, and adLockReadOnly
MarshalOptions
MaxRecords
PageCount
PageSize
Properties
RecordCount
Sort
Source
State
Status
StayInSync
Stream
Not Supported
ADOX Implementation Reference
This section documents Zen support of ADOX.
Catalog
Methods
Unsupported
Create
GetObjectOwner
SetObjectOwner
Properties
Supported
ActiveConnection
Tables
Unsupported
Groups
Procedures
Users
Views
Properties
Columns
Methods
Supported
Append
Delete
Unsupported
Refresh
Properties
Supported
Count
Item
Column
Properties
Supported
Attributes
DefinedSize
Name
NumericScale
ParentCatalog
Precision
Properties
Type
Unsupported
RelatedColumn
SortOrder
Group
Not Supported
Index
Properties
Supported
Columns
IndexNulls
Name
Properties
Unique
Unsupported
Clustered
PrimaryKey
Indexes
Methods
Supported
Append
Delete
Unsupported
Refresh
Properties
Supported
Count
Item
Connection
Unsupported
Procedure
Unsupported
Tables
Methods
Supported
Append
Delete
Unsupported
Refresh
Properties
Supported
Count
Item
Table
Properties
Supported
Indexes
Name
ParentCatalog
Type
Unsupported
DateCreated
DateModified
Keys
Visual Studio.NET Implementation Reference
This section lists the properties and methods supported by Zen with regards to .NET.
OleDbCommand Methods
Cancel
CreateParameter
CreateParameter
Dispose
ExecuteNonQuery
Note This method is expected to return -1 when execute DDL statements; The Zen OLE DB provider returns 0.
ExecuteReader
CloseConnection
KeyInfo
Default
SingleResult
SingleRow
ExecuteScalar
Prepare
OleDbCommand Properties
Connection
CommandText
CommandTimeout
Transaction
CommandType
Text
Stored Procedure
TableDirect
CommandUpdatedRowSource
OleDbCommandBuilder
All are supported
OleDbConnection Methods
Open
CreateCommand
Close
DatabaseChange
Note Zen OLE DB does not support modifying the current catalog.
BeginTransaction
GetOleDbSchemaTable
Columns
Indexes
ProviderTypes
Tables
OleDbConnection Properties
ConnectionString
DataBase
DataSource
Provider
ServerVersion
State
OleDbDataAdapter Methods
CreateTableMappings
CloneInternals
Fill
FillSchema
GetFillParameters
OnRowUpdated
OleDbDataAdapter Properties
MissingMappingsAction
MissingSchemaAction
AcceptChangesDuringFill
DeleteCommand
InsertCommand
SelectCommand
UpdateCommand
TableMappings
Columns
Table
DataColumn Properties tested with Zen OLE DB Provider
AllowDBNull
AutoIncrement
AutoIncrementSeed
AutoIncrementStep
 
ColumnName
DataType
Bit
System.Boolean
Tinyint
System.Int16
Utinyint
System.Byte
Blob
System.Byte[]
Binary(8)
System.Byte[]
Clob
System.String
Char
System.String
Numeric
System.Decimal
BigInt
System.Decimal
UBigInt
System.Decimal
Currency
System.Decimal
Decimal
System.Decimal
Int
System.Int32
UInt
System.Int64
SmallInt
System.Int16
USmallInt
System.Int32
Double
System.Double
Real
System.Single
Double
System.Double
Date
System.DateTime
Time
System.TimeSpan
TimeStamp
System.DateTime
VarChar
System.String
Identity
System.Int32
SmallIdentity
System.Int16
MaxLength
ReadOnly
Unique
OleDbDataReader Methods
Close
Read
GetBoolean
GetByte(Workaround: Use GetInt16)
GetChar (NOT supported)
GetDateTime
GetDecimal
GetDouble
GetFloat(Workaround: Use GetDouble)
GetInt16
GetInt32
GetInt64(Workaround: Use GetDecimal)
GetName
GetSchemaTable
GetString
GetTimeSpan
GetValue
GetValues
IsDBNull:
NextResult
OleDbDataReader Properties
Depth
Item
FieldCount
IsClosed
RecordsAffected
DataSet Methods Tested with OLE DB Provider
AcceptChanges
GetChanges
Merge
HasChanges
RejectChanges
Reset
DataSet Properties Tested with OLE DB Provider
CaseSensitive
DataSetName
DefaultViewManager
EnforceConstraints
HasErrors
Locale
Table
DataTable Methods Tested with OLE DB Provider
AcceptChanges
Clear
NewRow
DataTable Properties Tested with OLE DB Provider
ChildRelations
Columns
DataSet
Rows
TableName
DataRow Methods Tested with OLE DB Provider
AcceptChanges
RejectChanges
Delete
IsNull