Search:     Advanced search

Using TestTrack as a Knowledgebase

Article ID: 300  |  Last updated: 30 Dec, 2014

You can organize TestTrack information into an easy-to-use internal or external knowledgebase using ASP and the TestTrack ODBC driver. ASP allows you to limit what users can access. For example, you can restrict access to specific types of issues, such as those marked as closed, or only return specific fields, such as summary, description, and workaround. The example uses the TestTrack sample project as the knowledgebase.

IIS (Internet Information Server) is required to host the ASP. The TestTrack ODBC driver must also be installed and configured to access the sample database. You can customize the ASP files and the other information to provide access to specific databases and data.

Note: The TestTrack ODBC driver is only supported with TestTrack 2011.1.3 and earlier.

Downloading the sample ASP files

  1. Download the sample ASP files.
  2. Unzip the contents of into C:\Inet\pub\wwwroot.

Creating the virtual web site

The following instructions are for IIS 5.0. The steps you follow may be slightly different.

  1. Choose Start > Settings > Control Panel.
  2. Double-click Administrative Tools then double-click Internet Services Manager.
  3. In the left pane, right-click Default Web Site and choose New > Virtual Directory. The Virtual Directory Creation Wizard starts.
  4. Enter an alias name, such as ODBC_Sample and click Next.
  5. Click Browse to select the folder you unzipped the ASP files to. For example, C:\Inet\pub\wwwrooODBC_SampleDB. Click Next.
  6. Select Read and Run scripts (such as ASP). Make sure the other check boxes are cleared. Click Finish to complete the wizard.
  7. Close IIS.

Installing the TestTrack ODBC driver

  1. Download the ODBC driver.
  2. Unzip the ODBC zip file.
  3. Open the directory and double-click the Setup.exe file. The Welcome to TestTrack ODBC Setup dialog box opens. Click Next. The ODBC driver is automatically installed.
  4. Click OK when the installation finishes.

Creating the DSN

  1. Choose Start > Settings > Control Panel.
  2. Double-click Data Sources (ODBC). The ODBC Data Sources Administrator dialog box opens.
  3. Click the System DSN tab then click Add.
  4. Scroll down and select TestTrack ODBC Driver and click Finish.
  5. Enter "TestTrack _SampleDB" as the Data source name.
  6. Enter the full path to the TestTrack sample database. For example,C:\Program Files\Seapine\TestTrack\TTServDb\TTDbs\SampleDB.
  7. Click OK. You return to the ODBC Data Sources Administrator dialog box.

Accessing and searching the knowledgebase

  1. Open a browser and go to the address. For example, The sample knowledgebase search page opens.
  2. Enter the search criteria and click Search. Matching articles are returned.
  3. Click View Article to view the entire knowledgebase article.

Article ID: 300  |   Last updated: 30 Dec, 2014
ODBC knowledgebase ASP

Prev   Next
Cannot Connect to Server after Upgrading to Mac OS X 10.6     TestTrack SMTP Send Mail Error #503