dbExpress for ADO
Step By Step Guide

Installation

The driver is implemented in a dynamic link library DBEXPADO.DLL, which is loaded by Delphi's dbExpress components. Therefore Delphi 6 Professional or Enterprise Edition is required.

To install, copy DLL from Driver directory of installation package into your Windows system directory, which is Windows/System in case of Windows 95/98 or WINNT/System32 in case of Windows NT/2000/XP.

After that edit dbExpress configuration files, which can be found at /Program Files/Common Files/Borland Shared/DBExpress:

In the dbxdrivers.ini file, add ADO to the list of installed drivers.

For example:

[Installed Drivers]
Interbase=1
MYSQL=1
ADO=1

Then add an ADO section to describe the driver

[ADO]
GetDriverFunc=getSQLDriverADO
LibraryName=DBEXPADO.DLL
VendorLib=ANY.DLL
BlobSize=-1
Database=DBNAME
HostName=ServerName
Password=password
User_Name=user

After that add your individual database connection to the connections file. For example we will add 2 connections: AccessConnection and SQLServerConnection.

Add the following to dbxconnections.ini:

[AccessConnection]
BlobSize=-1
Database=Driver=Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyData\Northwind.mdb;Persist Security Info=False
DriverName=ADO

[SQLServerConnection]
BlobSize=-1
Database=Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Northwind
DriverName=ADO

This should be all that is needed to make the connection.