Watch, Follow, &
Connect with Us

Please visit our new home
community.embarcadero.com.


Welcome, Guest
Guest Settings
Help

Thread: OLEDBDAC for Delphi



Permlink Replies: 0 Threads: [ Previous | Next ]
Bismark Appah

Posts: 26
Registered: 3/13/15
OLEDBDAC for Delphi
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 29, 2017 2:08 AM
OLE DB Data Access Components (OLEDBDAC) is a feature-rich and high-performance library of components that provides data access for data sources exposed through OLE DB from Delphi for both 32-bit and 64-bit Windows platforms. OLEDBDAC-based applications connects to any data source exposed through OLE DB using the .NET Framework Data Provider for OLE DB. OLEDBDAC aims to assist programmers in developing of fast and native database applications whose data source is exposed through OLE DB. OLEDBDAC uses native OLE DB through COM interop to enable data access.

OLEDBDAC does not support OLE DB version 2.5 interfaces. OLE DB Providers that require support for OLE DB 2.5 interfaces will not function correctly with the OLE DB Data Access Components. This includes the Microsoft OLE DB provider for Exchange and the Microsoft OLE DB provider for Internet Publishing.

OLEDBDAC does not work with the OLE DB provider for ODBC (MSDASQL). To access an ODBC data source use the ODBC Data Access Components.

OLEDBDAC-based DB applications are easy to deploy, requires installation of OLE DB providers, uses ADO.Net technologies which makes it work faster than the ones based on standard Delphi data connectivity solutions.

NB: OLEDBDAC is part of the ADO.Net VCL for Delphi.

Key Features
- Direct access to server data via OLE DB providers.
- Interface compatible with standard data access methods, such as BDE and ADO
- Unicode support
- Easy to deploy
- Transmission is via XML format, therefore can pass through firewalls
- High overall performance
- Fast controlled fetch of large data blocks
- High performance of applying cached updates with batches
- Advanced connection pooling
- High performance batch processing
- Intelligent fetch block size control
- Support prefetching rows - specifies the number of rows that are to be fetched per server round trip. This is controlled by FetchOptions.RowsetSize property
- CachedUpdates operation mode which is controlled UpdateMode property
- Automatic data updating with TOleDbQuery, TOleDbTable, and TOleDbStoredProc components
- Fast data retrieval with TOleDbDataReader component
- Automatic record refreshing and locking
- Automatic query preparing
- Data export and import to/from XML
- Advanced design-time component and property editors
- and many more

For more information go to https://crystalnet-tech.com/ADONetVcl/OLEDBDAC.aspx
For more information about ADO.Net VCL for Delphi, go to https://crystalnet-tech.com/ADONetVcl/ADODotNet.aspx

Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02