pcsoft.us.windevCopyright 2026, PC SOFT29 Nov 2017 20:20:00 Z29 Nov 2017 14:26:00 ZHi, We have application developed in WINDEV. We have used SQL server. For one procedure we are getting following error: --------------------------- Adage - VTest - mode DEBUG - base ADAGE_PROD --------------------------- StatElt - Echec requête Req_Stat_CompDsDossier OLE DB access error. Error Number = 170129 Failure opening file. System Error Details: Description = Query timeout expired Source = Microsoft OLE DB Provider for SQL Server SQL State = HYT00 Error Number = -2147217871 Does anyone know why it's happening? How to resolve this?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63500-windev-sql-query-timeout/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63500-windev-sql-query-timeout-63505/read.awp29 Nov 2017 20:20:00 ZIt means the query take quite some time to finish, so I would first take the sql-text of your query from within the Windev query…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63500-windev-sql-query-timeout-63505/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63500-windev-sql-query-timeout-63505/read.awpWINDEV- SQL query timeoutguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63500-windev-sql-query-timeout-63502/read.awp29 Nov 2017 17:55:00 ZYou can add WD Command Timeout=0 to the extended properties of your connection. Check this help page: https://doc.windev.com/…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63500-windev-sql-query-timeout-63502/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63500-windev-sql-query-timeout-63502/read.awpWINDEV- SQL query timeoutguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63500-windev-sql-query-timeout-63503/read.awp29 Nov 2017 17:41:00 ZYou might also need to run "c:\windows\system32\odbcad32.exe" and click "Connection Pooling" Tab, highlight/click right drivers…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63500-windev-sql-query-timeout-63503/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63500-windev-sql-query-timeout-63503/read.awpWINDEV- SQL query timeoutguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63500-windev-sql-query-timeout-63501/read.awp29 Nov 2017 17:32:00 ZHi Give it a shout by running SSMS with followings sp_configure 'remote login timeout', 600 go reconfigure with override…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63500-windev-sql-query-timeout-63501/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63500-windev-sql-query-timeout-63501/read.awpWINDEV- SQL query timeout