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
Start OpenOffice Base, it will start with the Database Wizard.
Choose "Connect to an exisiting database" and select ODBC.
Click Next »
Click Browse and select "SQLite3 Datasource"
Now you are in the ODBC Data Source Administrator, you can start this also btw on Windows by running ODBCAD32.exe.
Choose as driver "SQLite3 ODBC Driver" and click Finish
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
And click OK once again in the ODBC Data Source Adminstrator
Now select the Schoolsplay datasource and click OK.
Click Next to advance to the user authentication step
Here, click Test Connection, this should return positive.
Click Finish and save the database
Navigate to the Tables icon and you'll see the tables in use in Schoolsplay.
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.