Database Drivers

A database driver enables you to access a remote database, first by recognizing the database and then by establishing a connection with it.

DB-Gate comes with pre-installed DB drivers. The default path for drivers is /iSecurity/DB-Gate/Drivers on the IBM i's IFS.

To list the DB drivers that have been established on your system, select 11. Work with DB Drivers from the DB-Gate main menu. The Work with DB Drivers screen appears:

​                             ​ Work with DB Drivers​                                                                        ​ Subset by driver  . .​           ​     ​  Type options, press Enter. ​                   ​ by text  . . . .​                ​   ​ 1=Select   3=Copy   4=Delete   8=Driver page​                                                                                                                  ​  Opt​ Driver​  ​ Available​                                                           ​  ​ ​ AS400DB2  ​ ​ Yes​ ​ DB2 on OS/400 platform                            ​          ​  ​ ​ BIG_SQL   ​ ​ Yes​ ​ Big SQL                                           ​          ​  ​ ​ CACHE     ​ ​  - ​ ​ Cache                                             ​          ​  ​ ​ CSV       ​ ​ Yes​ ​ CSV (Comma Separated Values)                      ​          ​  ​ ​ DAFFODILLO​ ​  - ​ ​ DaffodilDB Local                                  ​          ​  ​ ​ DAFFODILSR​ ​  - ​ ​ DaffodilDB Server                                 ​          ​  ​ ​ DB2       ​ ​ Yes​ ​ DB2 for Windows/Linux                             ​          ​  ​ ​ DB2JDBC4  ​ ​ Yes​ ​ DB2 for Windows/Linux                             ​          ​  ​ ​ DERBY     ​ ​ Yes​ ​ JavaDB/Derby                                      ​          ​  ​ ​ DERBYMY   ​ ​ Yes​ ​ JavaDB/Derby                                      ​          ​  ​ ​ EXCEL     ​ ​ Yes​ ​ Microsoft Excel                                   ​          ​  ​ ​ FEDERATED ​ ​ Yes​ ​ Federated database                                ​          ​  ​ ​ FIREBIRD  ​ ​ Yes​ ​ Firebird                                          ​          ​  ​ ​ FRONTBASE ​ ​ Yes​ ​ FrontBase                                         ​                                                                            ​      More...​  ​ F3=Exit    F6=Add new    F8=Print    F12=Cancel                              ​   ​                                                                                                                                                                  ​

For each driver, the body of the screen shows the driver's name, whether is it available, and a free-form description. A driver is marked as available if the path to the driver file has been set on its Modify DB Driver screen, as shown in Modifying a DB Driver.

To view a specific subset of drivers, do one of the following:

1. In the Subset by driver field, at the top right of the screen, enter the first alphanumeric characters of the Driver field and press Enter. The driver list is redisplayed with results that match your query.
2. In the Subset by text field, enter any alphanumeric characters you want to match in either the Driver or Description fields and press Enter. The driver list is redisplayed with results that match your query.

If the URL for the driver manufacturer's web page has been saved within the driver’s details, you can open the page in your browser and read detailed information on the database.

To view the manufacturer's page for the driver, type 8 in the Opt field for the driver and press Enter. The web page appears in your local computer's default browser.