White_Banner.jpg - 40746 Bytes
DATABASE CREATION (DBFILE)

PBM Client supports two database systems. The first is a database file system which is labeled "DBFILE". The DBFILE system does not require any external database systems and is very user friendly. The second database system supported by PBM Client is MySQL. Using MySQL requires that MySQL be installed on the computer that PBM Client resides on or that the PBM Client computer has access to a network computer with MySQL.

Database creation is accomplished by using the Database Creation Wizard. The database wizard is only available until a database and connection have been established. The wizard is launched by selecting the Database Builder menu item. as seen in the following picture.

Database Builder

If the database builder menu item is not available, then a database has already been created in which case there will be a menu item titled "Open Database", or the environment has not yet been set. See "Setting The Environment" for further instructions.

Selecting the Database Builder menu item will launch the database creation wizard as pictured below.

Database Builder DBFILE

After selecting "Powerball" from the available lotteries, and selecting DBFILE as the database system, the user must enter a Database Name and password for the database. If there are any associated files used to create the database such as running scripts that configure tables etc. they will be listed in the "Related Files" window. The user can also view the database tables and the associated table fields by selecting a table from the "Table" drop down menu.

The final step in the database creation process is to click on the "Create" button. The database creation wizard will create the database file, store the database connection details, and automatically close. PBM Client is now ready to open a database connection and update the database tables.