Ado Examples and Best Practices

2017-07-07 02:10:07

Team-Fly

CursorLocation: Server-side Cursors

Cursor

FwdOnly MSDASQL

LockType Requested	CursorLocation	LockType Opened	CursorType	Updatable	AddNew	AbsPosition	BookMark	Delete	Holdrecords	MovePrevious	Resync	BatchUpdate	Seek
ReadOnly	Server	ReadOnly	FwdOnly	No	No	No	No	No	No	No	No	No	No
Pessimistic	Server	Pessimistic	FwdOnly	Yes	Yes	No	No	Yes	No	No	No	Yes	No
Optimistic	Server	Optimistic	FwdOnly	Yes	Yes	No	No	Yes	No	No	No	Yes	No
Batch	Server	Batch	FwdOnly	Yes	Yes	No	No	Yes	No	No	No	Yes	No

Keyset MSDASQL

LockType Requested	CursorLocation	LockType Opened	CursorType	Updatable	AddNew	AbsPosition	BookMark	Delete	Holdrecords	MovePrevious	Resync	BatchUpdate	Seek
ReadOnly	Server	ReadOnly	Keyset	No	No	No	Yes	No	Yes	Yes	Yes	No	No
Pessimistic	Server	Pessimistic	Keyset	Yes	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	No
Optimistic	Server	Optimistic	Keyset	Yes	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	No
Batch	Server	Batch	Keyset	Yes	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	No

Dynamic MSDASQL

LockType Requested	CursorLocation	LockType Opened	CursorType	Updatable	AddNew	AbsPosition	BookMark	Delete	Holdrecords	MovePrevious	Resync	BatchUpdate	Seek
ReadOnly	Server	ReadOnly	Keyset	No	No	No	Yes	No	Yes	Yes	Yes	No	No
Pessimistic	Server	Pessimistic	Keyset	Yes	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	No
Optimistic	Server	Optimistic	Keyset	Yes	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	No
BatchO	Server	Batch	Keyset	Yes	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	No

Static MSDASQL

LockType Requested	CursorLocation	LockType Opened	CursorType	Updatable	AddNew	AbsPosition	BookMark	Delete	Holdrecords	MovePrevious	Resync	BatchUpdate	Seek
ReadOnly	Server	ReadOnly	Keyset	No	No	No	Yes	No	Yes	Yes	Yes	No	No
Pessimistic	Server	Pessimistic	Keyset	Yes	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	No
Optimistic	Server	Optimistic	Keyset	Yes	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	No
Batch	Server	Batch	Keyset	Yes	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	No

FwdOnly SQLOLEDB

LockType Requested	CursorLocation	LockType Opened	CursorType	Updatable	AddNew	AbsPosition	BookMark	Delete	Holdrecords	MovePrevious	Resync	BatchUpdate	Seek
ReadOnly	Server	ReadOnly	FwdOnly	No	No	No	No	No	No	No	No	No	No
Pessimistic	Server	Pessimistic	FwdOnly	Yes	Yes	No	No	Yes	No	No	No	Yes	No
Optimistic	Server	Optimistic	FwdOnly	Yes	Yes	No	No	Yes	No	No	No	Yes	No
Batch	Server	Batch	FwdOnly	Yes	Yes	No	No	Yes	No	No	No	Yes	No

Keyset SQLOLEDB

LockType Requested	CursorLocation	LockType Opened	CursorType	Updatable	AddNew	AbsPosition	BookMark	Delete	Holdrecords	MovePrevious	Resync	BatchUpdate	Seek
ReadOnly	Server	ReadOnly	Keyset	No	No	Yes	Yes	No	Yes	Yes	Yes	No	No
Pessimistic	Server	Pessimistic	Keyset	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Optimistic	Server	Optimistic	Keyset	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Batch	Server	Batch	Keyset	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No

Cursor

Dynamic SQLOLEDB

LockType Requested	CursorLocation	LockType Opened	CursorType	Updatable	AddNew	AbsPosition	BookMark	Delete	Holdrecords	MovePrevious	Resync	BatchUpdate	Seek
ReadOnly	Server	ReadOnly	Keyset	No	No	Yes	Yes	No	Yes	Yes	Yes	No	No
Pessimistic	Server	Pessimistic	Keyset	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Optimistic	Server	Optimistic	Keyset	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Batch	Server	Batch	Keyset	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No

Static SQLOLEDB

LockType Requested	CursorLocation	LockType Opened	CursorType	Updatable	AddNew	AbsPosition	BookMark	Delete	Holdrecords	MovePrevious	Resync	BatchUpdate	Seek
ReadOnly	Server	ReadOnly	Keyset	No	No	Yes	Yes	No	Yes	Yes	Yes	No	No
Pessimistic	Server	Pessimistic	Keyset	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Optimistic	Server	Optimistic	Keyset	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Batch	Server	Batch	Keyset	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No

FwdOnly Jet 4.0

LockType Requested	CursorLocation	LockType Opened	CursorType	Updatable	AddNew	AbsPosition	BookMark	Delete	Holdrecords	MovePrevious	Resync	BatchUpdate	Seek
ReadOnly	Server	ReadOnly	FwdOnly	No	No	No	No	No	No	No	No	No	No
Pessimistic	Server	Pessimistic	Keyset	Yes	Yes	No	No	Yes	Yes	Yes	No	Yes	No
Optimistic	Server	Optimistic	Keyset	Yes	Yes	No	No	Yes	Yes	Yes	No	Yes	No
Batch	Server	Batch	Keyset	Yes	Yes	No	No	Yes	Yes	Yes	No	Yes	No

Keyset Jet 4.0

LockType Requested	CursorLocation	LockType Opened	CursorType	Updatable	AddNew	AbsPosition	BookMark	Delete	Holdrecords	MovePrevious	Resync	BatchUpdate	Seek
ReadOnly	Server	ReadOnly	Keyset	No	No	No	Yes	No	Yes	Yes	No	No	No
Pessimistic	Server	Pessimistic	Keyset	Yes	Yes	No	Yes	Yes	Yes	Yes	No	Yes	No
Optimistic	Server	Optimistic	Keyset	Yes	Yes	No	Yes	Yes	Yes	Yes	No	Yes	No
Batch	Server	Batch	Keyset	Yes	Yes	No	Yes	Yes	Yes	Yes	No	Yes	No

Dynamic Jet 4.0

LockType Requested	CursorLocation	LockType Opened	CursorType	Updatable	AddNew	AbsPosition	BookMark	Delete	Holdrecords	MovePrevious	Resync	BatchUpdate	Seek
ReadOnly	Server	ReadOnly	Keyset	No	No	No	Yes	No	Yes	Yes	No	No	No
Pessimistic	Server	Pessimistic	Keyset	Yes	Yes	No	Yes	Yes	Yes	Yes	No	Yes	No
Optimistic	Server	Optimistic	Keyset	Yes	Yes	No	Yes	Yes	Yes	Yes	No	Yes	No
Batch	Server	Batch	Keyset	Yes	Yes	No	Yes	Yes	Yes	Yes	No	Yes	No

Static Jet 4.0

LockType Requested	CursorLocation	LockType Opened	CursorType	Updatable	AddNew	AbsPosition	BookMark	Delete	Holdrecords	MovePrevious	Resync	BatchUpdate	Seek
ReadOnly	Server	ReadOnly	Keyset	No	No	No	Yes	No	Yes	Yes	No	No	No
Pessimistic	Server	Pessimistic	Keyset	Yes	Yes	No	Yes	Yes	Yes	Yes	No	Yes	No
Optimistic	Server	Optimistic	Keyset	Yes	Yes	No	Yes	Yes	Yes	Yes	No	Yes	No
Batch	Server	Batch	Keyset	Yes	Yes	No	Yes	Yes	Yes	Yes	No	Yes	No

Cursor

FwdOnly MSDASQL

LockType Requested	CursorLocation	LockType Opened	CursorType	Updatable	AddNew	AbsPosition	BookMark	Delete	Holdrecords	MovePrevious	Resync	BatchUpdate	Seek
ReadOnly	Client	ReadOnly	Static	No	No	Yes	Yes	No	Yes	Yes	Yes	No	No
Pessimistic	Client	Batch	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Optimistic	Client	Optimistic	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Batch	Client	Batch	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No

Keyset MSDASQL

LockType Requested	CursorLocation	LockType Opened	CursorType	Updatable	AddNew	AbsPosition	BookMark	Delete	Holdrecords	MovePrevious	Resync	BatchUpdate	Seek
ReadOnly	Client	ReadOnly	Static	No	No	Yes	Yes	No	Yes	Yes	Yes	No	No
Pessimistic	Client	Batch	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Optimistic	Client	Optimistic	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Batch	Client	Batch	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No

Dynamic MSDASQL

LockType Requested	CursorLocation	LockType Opened	CursorType	Updatable	AddNew	AbsPosition	BookMark	Delete	Holdrecords	MovePrevious	Resync	BatchUpdate	Seek
ReadOnly	Client	ReadOnly	Static	No	No	Yes	Yes	No	Yes	Yes	Yes	No	No
Pessimistic	Client	Batch	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Optimistic	Client	Optimistic	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Batch	Client	Batch	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No

Static MSDASQL

LockType Requested	CursorLocation	LockType Opened	CursorType	Updatable	AddNew	AbsPosition	BookMark	Delete	Holdrecords	MovePrevious	Resync	BatchUpdate	Seek
ReadOnly	Client	ReadOnly	Static	No	No	Yes	Yes	No	Yes	Yes	Yes	No	No
Pessimistic	Client	Batch	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Optimistic	Client	Optimistic	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Batch	Client	Batch	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No

FwdOnly SQLOLEDB

LockType Requested	CursorLocation	LockType Opened	CursorType	Updatable	AddNew	AbsPosition	BookMark	Delete	Holdrecords	MovePrevious	Resync	BatchUpdate	Seek
ReadOnly	Client	ReadOnly	Static	No	No	Yes	Yes	No	Yes	Yes	Yes	No	No
Pessimistic	Client	Batch	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Optimistic	Client	Optimistic	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Batch	Client	Batch	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No

Keyset SQLOLEDB

LockType Requested	CursorLocation	LockType Opened	CursorType	Updatable	AddNew	AbsPosition	BookMark	Delete	Holdrecords	MovePrevious	Resync	BatchUpdate	Seek
ReadOnly	Client	ReadOnly	Static	No	No	Yes	Yes	No	Yes	Yes	Yes	No	No
Pessimistic	Client	Batch	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Optimistic	Client	Optimistic	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Batch	Client	Batch	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No

Cursor

Dynamic SQLOLEDB

LockType Requested	CursorLocation	LockType Opened	CursorType	Updatable	AddNew	AbsPosition	BookMark	Delete	Holdrecords	MovePrevious	Resync	BatchUpdate	Seek
ReadOnly	Client	ReadOnly	Static	No	No	Yes	Yes	No	Yes	Yes	Yes	No	No
Pessimistic	Client	Batch	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Optimistic	Client	Optimistic	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Batch	Client	Batch	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No

Static SQLOLEDB

LockType Requested	CursorLocation	LockType Opened	CursorType	Updatable	AddNew	AbsPosition	BookMark	Delete	Holdrecords	MovePrevious	Resync	BatchUpdate	Seek
ReadOnly	Client	ReadOnly	Static	No	No	Yes	Yes	No	Yes	Yes	Yes	No	No
Pessimistic	Client	Batch	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Optimistic	Client	Optimistic	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Batch	Client	Batch	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No

FwdOnly Jet 4.0

LockType Requested	CursorLocation	LockType Opened	CursorType	Updatable	AddNew	AbsPosition	BookMark	Delete	Holdrecords	MovePrevious	Resync	BatchUpdate	Seek
ReadOnly	Client	ReadOnly	Static	No	No	Yes	Yes	No	Yes	Yes	Yes	No	No
Pessimistic	Client	Batch	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Optimistic	Client	Optimistic	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Batch	Client	Batch	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No

Keyset Jet 4.0

LockType Requested	CursorLocation	LockType Opened	CursorType	Updatable	AddNew	AbsPosition	BookMark	Delete	Holdrecords	MovePrevious	Resync	BatchUpdate	Seek
ReadOnly	Client	ReadOnly	Static	No	No	Yes	Yes	No	Yes	Yes	Yes	No	No
Pessimistic	Client	Batch	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Optimistic	Client	Optimistic	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Batch	Client	Batch	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No

Dynamic Jet 4.0

LockType Requested	CursorLocation	LockType Opened	CursorType	Updatable	AddNew	AbsPosition	BookMark	Delete	Holdrecords	MovePrevious	Resync	BatchUpdate	Seek
ReadOnly	Client	ReadOnly	Static	No	No	Yes	Yes	No	Yes	Yes	Yes	No	No
Pessimistic	Client	Batch	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Optimistic	Client	Optimistic	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Batch	Client	Batch	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No

Static Jet 4.0

LockType Requested	CursorLocation	LockType Opened	CursorType	Updatable	AddNew	AbsPosition	BookMark	Delete	Holdrecords	MovePrevious	Resync	BatchUpdate	Seek
ReadOnly	Client	ReadOnly	Static	No	No	Yes	Yes	No	Yes	Yes	Yes	No	No
Pessimistic	Client	Batch	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Optimistic	Client	Optimistic	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Batch	Client	Batch	Static	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No

Team-Fly

Категории

Search