Data Links

TestStand 2019 Help

Edition Date: May 2019

Part Number: 370052AA-01

»View Product Info
Download Help (Windows Only)

You must define a data link when you specify the database where TestStand logs results or when you use the Database step types. Use the Data Link Properties dialog box to create or edit a data link connection string and to specify initialization properties for an Object Linking and Embedding Database (OLE DB) provider.

For example, to connect to a Microsoft SQL Server database, specify the Object Linking and Embedding Database (OLE DB) provider for an SQL Server, a server name, a database name, a user ID, and a password. To connect to a Microsoft Access database, specify Microsoft Jet in 32-bit TestStand and Microsoft ACE OLE DB in 64-bit TestStand or specify the OLE DB provider for Open Database Connectivity (ODBC) and an ODBC data source name. The ODBC data source name specifies which ODBC driver to use, the database file (.mdb), and an optional user ID and password. Use the ODBC Administrator on the Windows Control Panel to define ODBC data source names.

Note Note  Refer to the documentation for the database you use to determine whether and how you can communicate to the database securely. National Instruments recommends that you do not use a plain text password to connect to databases with sensitive information.

A connection string is a string version of the connection information in the data link required to open a session to a database. Use the Data Link Properties dialog box to build a connection string. The Data Link Properties dialog box and the information contained in the connection string vary according to the OLE DB provider. For example, a connection string for an SQL Server database might contain the following information:

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=True;User ID=guest;Initial Catalog=pubs;Data Source=SERVERCOMPUTER

Complete the following steps to store the contents of a connection string in a Microsoft Data Link file (.udl).

  1. Create a Data Link file by right-clicking in Windows Explorer and selecting New»Text Document.
  2. Change the file extension to .udl.
  3. Right-click the new file and select Open to launch the Data Link Properties dialog box.
  4. Click the Connection tab and enable the Use connection string option.
  5. Click the Build button to launch the Select Data Link dialog box, in which you can build a connection string. When you finish, click OK to close the Select Data Link dialog box.
  6. Use the other options on the Provider, Connection, Advanced, and All tabs to provide additional configuration information for the .udl file.
  7. Click OK to close the Data Link Properties dialog box. The .udl file automatically saves when you exit the dialog box.

See Also

Configuring Connection Strings


Not Helpful