Configuring Database Drivers

Drivers for SQL Databases are implemented as .DLLs. Before you can use a database driver, Database Builder must load the driver software contained in the DLL.

Database Builder contains a 'Driver Administrator' which allows you to load drivers on-demand and to configure which drivers should be loaded automatically when you start Database Builder.

Select 'Configure Drivers' from the Tools menu. This activates the Driver Administrator dialog.

The Driver Administrator dialog is divided into two panels:

  1. The 'Driver Overview' (left) panel. This is a treeview that lists each driver and indicates whether that driver is currently loaded.

  2. The 'Driver Details' (right) panel. This is used to edit the configuration of the currently highlighted driver in the driver overview.

 

Driver Overview

This treeview lists each driver that is installed with DataFlex and indicates whether that driver is currently loaded. When you select a driver in the treeview, detailed information about that driver is displayed in the driver details panel.

The bottom node in the treeview is labeled 'Other Drivers'.  This item is used for loading third-party drivers.

Below is a guide to the icon symbols used to represent each driver.

 This symbol indicates that the driver is currently loaded.

 This symbol indicates that the driver is not currently loaded.

Driver Details

 

Driver Name

This is the name of the driver's .DLL file (without the .DLL extension). This name is used in DataFlex commands that require a driver name parameter. You cannot edit this value.

Load On Startup

Check this item to ensure that the driver will be loaded automatically whenever Database Builder is started.

Special Note
 

Load Now

Click the 'Load Now' button to load the selected driver now. You would use this button to load a driver on an as-needed basis.

Advanced…

Click the 'Advanced' button to activate the Advanced Driver Options dialog. This dialog is used to edit the drivers global configuration .INI file.

Other Drivers

Whenever you select the 'Other Drivers' item in the driver overview, a list of all 3rd party drivers that are currently loaded is displayed in the driver details panel.

You can load additional 3rd party drivers by selecting the 'Other Drivers' item in the overview, then clicking the 'Load Now' button. In this case, the 'load now' button activates the open file dialog. You will select the 3rd party driver's .DLL file from this dialog in order to load the driver.

OK

Click 'OK' to close this panel.

See Also

Connecting to SQL Databases

Advanced Driver Options