Apollo OLEDB > Using Apollo OLEDB > Using with Delphi & C++Builder

Apollo VCL is specifically designed for use with Delphi and C++Builder, however Apollo OLEDB can be used since Delphi and C++Builder support ADO.

To use Apollo OLEDB within Delphi follow these steps:

1.Install Apollo OLEDB, start Delphi and select "New | Application" from the main menu.

2.Drop TADOConnection, TADOTable and TDataSourece components on the main form.

3.Set the TADOConnection.ConnectionString to:

Provider=ApolloOLEDB9.ApolloOLEDB9;

Data Source=C:\Apollo\9.9\Data;

Mode=Read|Write;

TableType=ttSXFOX

Change Source as needed: e.g Source=c:\SampleData;

Change TableType as needed: ttSXFOX, ttSXNSX, ttSXNSX_DBT

4.TADOTable.CursorLocation should be clUseServer.

clUseClient is very slow and it does not support data updates and data refreshing.

5.Set TADOTable.Connection to the ADOConnection component.

6.Set TADOTable.TableDirect to True.

7.Select a table from the TADOTable.TableName property.

8.Connect data-aware components (TDBGrid, TDBNavigator, etc.) to the TDataSource component.

9.Set TADOTable.Active to True.