Showing results for 
Search instead for 
Did you mean: 

Time out error

Go to solution
I am using sql server 2000 as database. A table has some lakhs of records. while i am changing all records or altering the table,
I am receiving this error.. if u know.. please reply me...
Error Code :-      -2147217871
Error Source:-     Conn>Untitled 1<ERR>Exception occured in Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC SQL Server Driver]Timeout expired in Conn>Untitled 1

Thanks in Advance..
Vaira muthu

Message Edited by vaira muthu on 02-01-2008 05:21 AM
0 Kudos
Message 1 of 4
Accepted by topic author Vairamuthu

This error originates in DB Tools Execute because the timeout period by default for the VI is 30 seconds. This is not a LabVIEW error. It is an error generated by the ODBC driver being used. This is easily overcome by increasing the timeout for the command as some queries may take longer than the default timeout period.

There are two potential solutions that have been found.
  1. Within the DB Tools Execute, a while loop can be placed around the Invoke node for the execute method. The error response from this then needs to be monitored and the while loop condition set appropriately.

  2. Increase the command timeout using the DB Tools Set Set this property to a level in seconds that will not expire as a result of running the query.
Hope this helps!

Brian T
Applications Engineer
Message 2 of 4
Thank you for your answer..
Vaira muthu
0 Kudos
Message 3 of 4

Hello Brian,

I tried to use DB Tools Set Properties VI for modifying timeout, but i am getting following error. Also attaching the LV Code.


Thank you in advance,


Download All
0 Kudos
Message 4 of 4