tracker3.ini
The tracker3.ini file contains information about database providers, locations and connection settings, as well as optional values that modify Progress Tracker functions. This information is used by Progress Tracker, Progress Tracker Administrator, and Progress Tracker Reporter. The tracker3.ini file must be located in the sysToolBookDirectory.
The tracker3.ini file is largely controlled by Progress Tracker, but you will typically need to write the relevant portions of this file as part of your installation.
This topic describes the tracker3.ini sections and items. All items are optional unless otherwise indicated.
1. Provider
Sections
Progress Tracker lets you use one of three provider options for your application: JET, SQL, or ASP. Each of these options can have corresponding data in the tracker3.ini file.
Both the JET and SQL options have a Provider item that indicates the Provider element of the
connection string.
Example:
[SQL]
Provider=SQLOLEDB
[JET]
Provider=Microsoft.JET.OLEDB.4.0
The ASP option has three items that indicate the names of the ASP pages on the web server.
Example:
[ASP]
readData=tbkTrackerRead.asp
writeData=tbkTrackerWrite.asp
formatData=tbkTrackerFormat.asp
2. Databases Section (Required)
Each Progress Tracker application must be associated with a unique database. The association is established using a Database ID. The Database ID, stored as the progressTrackerDatabaseID property of your book, appears as an item under the Databases section in the tracker3.ini file. Its value is the selected provider option for your application.
Example (showing four separate applications):
[Databases]
sportsSampleModules=JET
parrotSpecies=SQL
USGeography=ASP
nurseryRhymeOrigins=ASP
3. [<Database ID>] Sections
Each Database ID that appears under the Databases section has its own section and items. The items will vary depending on the provider option for the corresponding application. Here are the possible items:
Provider-Specific Items
|
Item |
Explanation
|
|
JET_Source |
This item is required in two cases: when the provider option is JET, or when the provider option is ASP and the ASP_Provider (see below) is JET. The latter case is only required for the Progress Tracker Administrator and Reporter.
JET_Source is the path to the database file. The path can be complete or relative to the ToolBook author/runtime directory.
|
|
SQL_Source SQL_Initial Catalog |
These items are required in two cases: when the provider option is SQL, or when the provider option is ASP and the ASP_Provider (see below) is SQL. The latter case is only required for the Progress Tracker Administrator and Reporter.
SQL_Source is the server name for the database. SQL_Initial Catalog is the database name.
|
|
ASP_Source ASP_Provider |
These items are required when the provider option is ASP.
ASP_Source is the URL that contains the ASP files used by Progress Tracker. ASP_Provider is used by the Progress Tracker Administrator and Reporter to determine the provider type for the local database.
|
|
These optional items only apply to the JET and SQL provider options. Use them if you want to modify the corresponding connection settings.
| |
|
<providerOption>_key1 <providerOption>_key2 |
These items store encrypted values corresponding to the database. They are written from the Progress Tracker Administrator and should not be modified directly.
|
General (Not Provider-Specific) Items
|
Item |
Explanation
|
|
description |
Short description of database. Typically entered via Progress Tracker Administrator.
|
|
|
Set showProgress to TRUE to display a progress bar at login. If TRUE, the bar displays if the number of users in the database is greater than or equal to numUsersForShowingProgress.
|
|
Set this item to TRUE to show a splash graphic at login. The splash graphic must be named <Database ID>.bmp and be located in the sysToolBookDirectory.
| |
|
|
Set this item to TRUE to change Progress Tracker's print method from textToPrinter to shellExecute. See the Progress Tracker Developer help for details.
|
|
doNotAttachToEmail |
Set this item to TRUE to bypass automatic attachments when emailing reports. See the Progress Tracker Developer help for details.
|
|
useTypeinFullAnsw |
Set this item to TRUE to display fill-in-the-blank answers exactly as stored by ToolBook. See the Progress Tracker Developer help for details. |
|
|
|
|
Various settings to change the number of rows that are read per database read. |
See: numRows
|
Examples:
[sportsSample]
;Comment: Provider option is JET.
description=Progress Tracker Sports Sample
numUsersForShowingProgress=10
showProgress=TRUE
showSplash=TRUE
JET_Mode=3
JET_CursorLocation=2
JET_Source=E:\Progress Tracker\version 3\sports sample\data\sportsSample.mdb
JET_key1=^^d]_
JET_key2=q\b
[parrotSpecies]
;Comment: Provider option is SQL.
description=Documents characteristics of popular parrot species.
SQL_Source=(local)
SQL_Initial Catalog=Parrots
SQL_key1=^]_^tw
SQL_key2=aasdf
[USGeography]
;Comment: Provider option is ASP. Note ASP_Provider is JET.
description=Overview of major physical geographical features of the continental U.S.
ASP_Source=http://learningandmastering.com/usgeography
ASP_Provider=JET
JET_Source=E:\trainingSamples\USGeography\data\USGeo.mdb
JET_key1=^^d]_
JET_key2=q\b
[nurseryRhymeOrigins]
;Comment: Provider option is ASP. Note ASP_Provider is SQL.
description=History and meaning of popular nursery rhymes.
ASP_Source=http://learningandmastering.com/rhymes
ASP_Provider=SQL
SQL_Source=(local)
SQL_Initial Catalog=NurseryRhymes
SQL_key1=^]_^tw
SQL_key2=aasdf
4. Database Default Section
The Database Default section is used by Progress Tracker Administrator to determine which database is selected when the Administrator opens. Installation programs should set this value only if it is not already set by a previous program.
Example:
[Database Default]
default=sportsSample
|