1. How to connect to ADO data source?

   Put TSQLConnection on the form Set ConnectionName property (any name) Set DriverName property (any name) Set GetDriverFunc property to getSQLDriverADO Set LibraryName property to dbexpado.dll Assign ADO Connection String to Database parameter of Params property Set UserName and Password parameters if needed

2. How to connect to ODBC data source?

   Put TSQLConnection on the form Set ConnectionName property (any name) Set DriverName property (any name) Set GetDriverFunc property to getSQLDriverODBC Set LibraryName property to dbexpodbc.dll Assign ODBC Connection String to Database parameter of Params property For SQL Server: "Driver={SQL Server};Server=(local);Database=Northwind;" For Access: "Driver={Microsoft Access Driver (*.mdb)};DBQ=..\Data\Northwind.mdb;"

3. How to create configuration file dbexpado.ini?

   Configuration file dbexpado.ini is needed only when you need to specify CursorLocation of ADO Recordsets, that are used in dbExpress for ADO.

   dbexpado.ini format:

   [Connection Parameters]
   CursorLocation=adUseServer (or adUseClient)

   You can put it in working folder of your application or in DBExpress configuration folder (usually /Program Files/Common Files/Borland Shared/DBExpress).
   If you want to use dbexpado.ini file from DBExpress configuration folder, you also need to add key value to registry at:

   HKEY_CURRENT_USER/Software/Borland/DBExpress/

   Add string value:

   dbExpress for ADO Registry File=C:\Program Files\Common Files\Borland Shared\DBExpress\dbexpado.ini (or path to your location)

4. Why MasterDetail Demo for SQL Server gives me error message?

   MasterDetail demo for SQL Server uses modified Northwind database, which comes with SQL Server.
   Since Borland's ClientDataSet architecture doesn't support table names with spaces you need to rename Order Details table to OrderDetails.

       This section is currently under construction. If you have any technical or common questions about dbExpress for ADO, then, please, feel free to direct them to dbExpress for ADO/ODBC Support.