OLEDB Direct 1.85 is released

From: Viatcheslav V. Vassiliev (support_at_oledbdirect.com)
Date: 10/05/04 

Date: Tue, 5 Oct 2004 16:02:51 +0400

OLEDB Direct Components Suite (http://www.oledbdirect.com) is a set of
VCL-style components for Delphi 4 - 7 and C++ Builder 4 - 6 that allow
database access using OLEDB interfaces (these interfaces ADO uses
internally). It is designed for extremely fast data access and it provides a
possibility to use database services that are additionally implemented by
OLEDB provider (such as bulk rowsets in MS SQL Server OLEDB provider). OLEDB
Direct Components Suite should be used if you need to work with very large
amount of data. For example, with OLEDB Direct you will be able to insert 1
000 000 rows in MS SQL Server in 10 seconds on modern computer (< 1 minute
on most computers).

OLEDB is native data-access technology for Microsoft DBMS (MS SQL Server and
MS Jet/MS Access) and OLEDB Direct provides the fastest way to those DBMS.

OLEDB Direct includes OLEDB Express - dbExpress driver for MS SQL Server, MS
Jet (MS Access) and MS Excel databases. OLEDB Express is available as
separate product too.

In this release:

  * ExecuteRow() method that allows fetch first record into array of Variant
    without actually open TOLEDBRowset or TOLEDBDataSet.
  * Enhanced Locate() to work on server-side cursor.
  * Minor enhancements.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

Relevant Pages

  • Re: oledbconnection v sqlconnection
    ... The OleDb provider is a one-size-fits-all data access interface that uses ... No two database engines have the same SQL so you'll have to ... actual low-level data access layer and exposes a common object layer that ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: msde2000
    ... MSDE is the desktop version of SQL server. ... Basically, Access is a desktop application, MSDE is a database backend. ... go through OLEDB, so theoretically therefore it's arguably the fastest ...
    (microsoft.public.vc.language)
  • RE: Allowing user selection of a datasource at run time?
    ... but you can build connection strings to connect to any OLEDB ... the SQL Server instances, which is much easier. ... I need to allow> a user to select a database to connect to at run time via a standard dialog> box. ... This causes the 'Data Link Properties' dialog box to appear> which allows the user to select an OLEDB data provider, and a database, etc. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: OLEDBCommand vs. SQLCommand
    ... Thanx Seth & Pamela, that does help. ... Access is SQL Server lite. ... all the servers my company uses, meaning either OleDb or ODBC (and I ... but may be your only choice depending on the database. ...
    (microsoft.public.dotnet.languages.vb)
  • ANN: OleDb Direct is updated to version 1.73
    ... database access using OLEDB interfaces (these interfaces ADO uses ... possibility to use database services that are additionally implemented by ... OLEDB provider (such as bulk rowsets in MS SQL Server OLEDB provider). ... with OLEDB Direct you will be able to insert 1 ...
    (borland.public.delphi.thirdpartytools.general)