Add Database
|
|
You click this button on the Select Progress Tracker Database screen to add a new database to Progress Tracker Administrator. You might do this if you are creating a new project and want it to have its own database. You could duplicate and rename the existing database and then click this button to set it up. |
Progress Tracker prompts you for each piece of information in turn.
1. This is a description of your database. End users will never see this description. It is only used within the Administrator and using the Progress Tracker tools in a front end book.
2. You next need to pick the provider option.
If you selected ASP, you will see these dialog boxes:
Since the ASP provider communicates with the database via Active Server Pages, we need to select how the Administrator and Reporter will communicate with the database. You may choose either JET (Access database) or SQL (SQL Server). Notice that you will need to ftp your database from your web server to a local drive in order to connect to it from the Administrator or Reporter when you are using JET.
You will next need to select the URL at which your ASP pages are located. This information is not used by the Administrator or Reporter but is required by the students running Progress Tracker courses.
3. This next step depends on whether you selected JET or SQL. If you selected ASP, then this step is determined by the "Local ASP Provider Type" that you selected.
JET
This is the location on your current system where the database is located. Notice that a relative path is from the sysToolBookDirectory. You may click the ... button to select an existing database. Note that this and other database information is stored in the tracker3.ini file located in the ToolBook directory. The installation routine would typically write the correct location to this file (if you don't use a relative path [we recommend a relative path instead]).
SQL
For SQL Server, we have two choices. The first is the name of the server that we are using. Notice that this can be an alias to a SQL Server located on a web server. You would create this alias using SQL Server's "Client Network Utility."
You then enter the name of the initial catalog (database) that contains your course(s). Be sure that you have used SQL Server to create a user name and password (SQL Server authentication rather than Windows authentication). You will need this when prompted to enter the username and password of the database.
4. The last step is to enter a unique identifier for this database. This identifier is what your ToolBook module and, if applicable, front end book, uses to determine which database to open. You must therefore set the 'progressTrackerDatabaseID' property of the module and/or front end book to this same value.
Progress Tracker Administrator will prompt you to edit the username and password of the database when you try to close the dialog box. Or, you can click the "Edit DB" button and then the Password choice to do it first.
 |
