PSQL OLE DB Provider Implementation
 
PSQL OLE DB Provider Implementation
Reference of Supported Properties, Methods, and Events
The chapter contains the following topics:
OLE DB Provider Implementation Reference
ADOX Implementation Reference
Visual Studio.NET Implementation Reference
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