PSQL OLE DB Provider Implementation
Reference of Supported Properties, Methods, and Events
The chapter contains the following topics:
OLE DB Provider Implementation Reference
This section lists specifics with regard to the PSQL 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 should only be used after researching Microsoft’s Client Cursor Engine
•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
•This gives the size that we hold in the database
•This is only accurate to 65k on LongVarBinary and LongVarChar, after that the length can only be found 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 PSQL 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 PSQL with regards to .NET.
OleDbCommand Methods
Cancel
CreateParameter
CreateParameter
Dispose
ExecuteNonQuery
Note This method is expected to return -1 when execute DDL statements; The PSQL 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 PSQL 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 PSQL 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