Correctly Setting the Connection String Expression in the TestStand Properties Loader for the PostgreSQL Database

Updated Oct 28, 2024

Environment

Software

  • TestStand

To connect to a PostgreSQL database using the Property Loader step, perform the following steps:

1. Check if you had installed the ODBC driver for PostgreSQL if not, please perform the following steps from this article: Configure ODBC drivers for PostgreSQL.
2. Then, after checking/installing, please open TestStand.
3. Select Configure - Result Processing

Capture.PNG

4. From the pop-up window, select database Options

db.PNG

5. In the new window, select Build

db1.PNG

6. Go to Provider, select OLE DB Provider for Microsoft Directory Services, and click Next

db2.PNG

7. Here you must fill in the following fields
  1. Data Source (Please go to this * step )
  2. Location (location of your system)
  3. User Name
  4. Password
8. When complete, please Test Connection and click OK if everything works.   

db3.PNG  

9. Then copy Connection String Expression to the Property Loader SOURCE LOCATION

db4.PNG


* Name of your Data Source you can find from the ODBC Data Source Administrator

db5.PNG

Related Links

Other Support Options

Ask the NI Community

Collaborate with other users in our discussion forums



Request Support from an Engineer

A valid service agreement or active software subscription may be required, and support options vary by country.