Error -2147217871 When Using SQL Database

Updated Jun 8, 2020

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.