tbksettg3.ini
The tbksettg3.ini file contains information about database providers, locations and connection settings, as well as optional values that modify TBK Tracker functions. This information is used by TBK Tracker, TBK Tracker Administrator, and TBK Tracker Reporter. For ToolBook deployment, the tbksettg3.ini file must be located in the sysToolBookDirectory. For Flash deployment, the file can be in any location. However, the TBK Tracker Administrator configuration files must then be pointed to the correct location of tbksettg3.ini.
The tbksettg3.ini file is largely controlled by TBK Tracker, but you typically will need to write the relevant portions of this file as part of your installation.
This topic describes the tbksettg3.ini sections and items. All items are optional unless otherwise indicated.
1. Provider
Sections
TBK 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 tbksettg3.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. Note that ASP is only supported in ToolBook.
Example:
[ASP]
readData=tbkTrackerRead.asp
writeData=tbkTrackerWrite.asp
formatData=tbkTrackerFormat.asp
2. Databases Section (Required)
Each TBK Tracker application must be associated with a unique database. The association is established using a Database ID. The Database ID, stored as the tbkTrackerDatabaseID property of your front end book or the Training_DatabaseName setting in the TBKTrackerProjector.exe.config file, appears as an item under the Databases section in the tbksettg3.ini file. Its value is the selected provider option for your application.
Example (showing four separate applications):
[Databases]
sportsSample=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 TBK 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 or the location of the tbksettg3.ini file (Flash).
|
|
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 TBK 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 TBK Tracker. ASP_Provider is used by the TBK 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 TBK Tracker Administrator and should not be modified directly.
|
General (Not Provider-Specific) Items
|
Item |
Explanation
|
|
description |
Short description of database. Typically entered via TBK 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 ToolBook author/runtime directory.
| |
|
|
Set this item to TRUE to change TBK Tracker's print method from textToPrinter to shellExecute.
|
|
Set this item to TRUE to bypass automatic attachments when emailing reports.
| |
|
Set this item to TRUE to display fill-in-the-blank answers exactly as stored by ToolBook. | |
|
|
|
|
numUserRows numCourseRows numGlobalRows numStudentCourseInformationRows numStudentCourseAssignmentRows numClassCourseAssignmentRows numSessionCourseRows numCourseLessonAssignmentRows numLessonsRows numStudentLessonInformationRows numPropertyLessonInformationRows numStudentLessonPropertyRows numSessionLessonRows numLessonTestRows |
These items allow you to modify the number of rows retrieved via extGetString queries.
|
Examples:
[sportsSample]
;Comment: Provider option is JET.
description=TBK Tracker Sports Sample
numUsersForShowingProgress=10
showProgress=TRUE
showSplash=TRUE
JET_Mode=3
JET_CursorLocation=2
JET_Source=E:\TBK 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 TBK 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
|