How to open the Schoolsplay database in Windows

Introduction

We have chosen to use OpenOffice Base to make reports of the Schoolsplay progress.
The reasons are obvious: OpenOffice is also open-source, it runs on all platforms and has good support. You can download it at www.openoffice.org.

A very good support forum for OpenOffice can be found at www.oooforum.org/.

I will be explaining the procedure here for Windows based systems, for GNU/Linux based systems see Howto open the database GNU/Linux.

Installing SQLite ODBC driver

To be able to access the SQLite database that Schoolsplay for now uses, you need to install a driver for it, this can be found at www.ch-werner.de/sqliteodbc/

Download the package appropriate for your platform and install it.

Making an OpenOffice Base document that point to sp.db

Step1

Start OpenOffice Base, it will start with the Database Wizard.
Choose "Connect to an exisiting database" and select ODBC.
Click Next »

1_step1-selectdatabase.png

Step2

Click Browse and select "SQLite3 Datasource"
Click Organize…

2_step2-setupodbc.png

Step3

Now you are in the ODBC Data Source Administrator, you can start this also btw on Windows by running ODBCAD32.exe.
Click Add…

3_step3-odbcadmin.png

Step4

Choose as driver "SQLite3 ODBC Driver" and click Finish

4_step3-newdatasource.png

Step5

Fill the options
Data Source Name = Schoolsplay (you may change this whatever you like)
Database Name = Enter or browse to the path of the schoolsplay database
Lock Timeout = 100000
Sync Mode = NORMAL
Click OK

5_step3_dsn_config.png

And click OK once again in the ODBC Data Source Adminstrator

Step6

Now select the Schoolsplay datasource and click OK.

6_step3_select.png

Click Next to advance to the user authentication step

Step7

Here, click Test Connection, this should return positive.

7_step3_connectiontest.png

Step8

Click Finish and save the database

8_step4_save.png

Step9

Navigate to the Tables icon and you'll see the tables in use in Schoolsplay.

9_base.png

Great! Now you can open the Schoolsplay database in OpenOffice Base.
In the future, we will try to provide you with a Base document that contains some commonly used Queries, Forms and Reports.
For now, you can must your own, but please send them back to us.

Unless otherwise stated, the content of this page is licensed under GNU Free Documentation License.