Watch, Follow, &
Connect with Us

Please visit our new home
community.embarcadero.com.


Welcome, Guest
Guest Settings
Help

Thread: ODBCDAC for Delphi



Permlink Replies: 2 - Last Post: Jan 11, 2018 4:48 PM Last Post By: Bismark Appah
Bismark Appah

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

ODBCDAC-based DB applications are easy to deploy, requires installation of ODBC drivers, uses ADO.Net technologies and works faster than the ones based on standard Delphi data connectivity solutions.

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

Key Features
- Direct access to server data via ODBC 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 TOdbcQuery, TOdbcTable, and TOdbcStoredProc components
- Fast data retrieval with TOdbcDataReader 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/ODBCDAC.aspx
For more information about ADO.Net VCL for Delphi, go to https://crystalnet-tech.com/ADONetVcl/ADODotNet.aspx

Edited by: Bismark Appah on Dec 29, 2017 10:02 AM

Edited by: Bismark Appah on Dec 29, 2017 10:08 AM
Registered User

Posts: 46
Registered: 3/4/05
Re: ODBCDAC for Delphi
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 4, 2018 2:53 PM   in response to: Bismark Appah in response to: Bismark Appah
What are advantages over FD or built in ADO?
Bismark Appah

Posts: 26
Registered: 3/13/15
Re: ODBCDAC for Delphi
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 11, 2018 4:48 PM   in response to: Registered User in response to: Registered User
Registered User wrote:
What are advantages over FD or built in ADO?

The following are some of the advantages of the ODBCDAC for Delphi over FD or ADO:

- High performance access to the data source.
- Fast-forward data retrieval with TOdbcDataReader component.
- Fast controlled fetch of large data blocks.
- Transmission is via XML format, therefore can pass through firewalls.
- Support prefetching rows - specifies the number of rows that are to be fetched per server round trip. This is controlled by FetchOptions.RowsetSize property.
- High performance of applying cached updates with batches.
- High performance batch updates processing.
- Automatic record refreshing and locking.
- Automatic query preparing.
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02