tbksettg4.ini

The tbksettg4.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. The tbksettg4.ini file must be located in the sysToolBookDirectory.

 

The tbksettg4.ini file is largely controlled by TBK Tracker, but you will typically need to write the relevant portions of this file as part of your installation. See Distributing Your TBK Tracker Application for more information.

 

This topic describes the tbksettg4.ini sections and items. All items are optional unless otherwise indicated.

 

  1. Provider Sections
     

  2. 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 tbksettg4.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 this is no longer supported via the TBK Tracker Administrator but is included for backward-compatibility.

     

    Example:


    [ASP]

    readData=tbkTrackerRead.asp

    writeData=tbkTrackerWrite.asp

    formatData=tbkTrackerFormat.asp

     

  3. Databases Section (Required)

  4.  

    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 frontend book, appears as an item under the Databases section in the tbksettg4.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

     

  5. [<Database ID>] Sections

  6.  

    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.

     

    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.

     

    <providerOption>_CursorLocation

    <providerOption>_Mode

    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.

     

    showProgress

    numUsersForShowingProgress

     

    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.

     

    showSplash

    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.

     

    shellExecutePrint

     

    Set this item to TRUE to change TBK Tracker's print method from textToPrinter to shellExecute.

     

    doNotAttachToEmail

    Set this item to TRUE to bypass automatic attachments when emailing reports.

     

    useTypeinFullAnsw

    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

     

  7. Database Default Section

  8.  

    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

     

    See also:

    TBK Tracker System Files