Complete the following steps before you use the default process model to log results to a database.

  1. Ensure that you thoroughly understand fundamental database concepts.
  2. Decide which database management system (DBMS) you want to use. By default, TestStand supports SQL Server, Oracle, Microsoft Access, Sybase, and MySQL. You can add support for other database management systems.
  3. Ensure you installed the appropriate client DBMS software required to communicate with the DBMS. You must decide to use an Open Database Connectivity (ODBC) driver or a specific Object Linking and Embedding Database (OLE DB) provider for the DBMS. Use the OLE DB providers for SQL Server and Access. Most Oracle ODBC drivers and OLE DB providers require that you install Oracle Client. Refer to the Recommended Database Client Software section of the NI TestStand Readme for more information about suggested providers, versions of ODBC drivers, client DBMS software, and any known issues.
  4. Create the default database tables in the DBMS. The <TestStand>\Components\Models\TestStandModels\Database directory contains SQL script files to create and delete the default database tables the default TestStand schemas require. For example, the Access Create Generic Recordset Result Tables.sql file contains SQL commands to create the default tables for Access. The Access Drop Result Tables.sql file contains SQL commands to delete the default tables. TestStand includes an example Access database, TestStand Results.mdb, in the <TestStand>\Components\Models\TestStandModels\Database directory. You can also create the default database tables using an SQL script file.
  5. Use the Database Options dialog box to enable database logging and to define a data link and schema for the default process model to use.