Error -2147217871 When Using SQL Database

Updated Apr 3, 2023

Reported In

Software

  • TestStand
  • LabWindows/CVI

Issue Details

  • I try to communicate with my SQL database using DBActivateMap in LabWindows/CVI, but I keep getting the error -2147217871 - The timeout expired. How do I fix this?
  • I am using a SQL Database to log my data in TestStand but am getting error -2147217871 saying the process times out. 

Solution

This error is caused by running out of time before the database returns a response. Sometimes it takes a while to receive a response because of the large size of a database.

Two ways to resolve this error are as follows:
  • Change the timeout for the process so it is longer or get rid of the timeout
  • Change the amount of data you are querying the SQL database for to only request a small subset instead of the whole table.

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.