Skip to content

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. Driver Overview (left panel): This is a treeview that lists each driver and indicates whether that driver is currently loaded.
  2. 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

  • This makes an entry for the driver in the global \usr\dfini.ini file. This setting will cause the driver to be automatically loaded for every DataFlex application that you run.

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 third-party drivers that are currently loaded is displayed in the driver details panel.

You can load additional third-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 third-party driver's .DLL file from this dialog in order to load the driver.

OK

Click OK to close this panel.

See Also