pcsoft.us.windevCopyright 2026, PC SOFT23 Oct 2014 23:16:00 Z23 Oct 2014 21:28:00 ZOur application uses a SQL Server 2014 database. When we get disconnected we will get this error the following HyperFileSQL error occurred: ============================= OLE DB access error. Error Number = 170129 Failure opening file. ============================= We solved it in WD 16 with the procedure below, but it stopped working after upgrading to WD 18 dsTest is Data Source sTest is string = [ SELECT[TestID] FROM [Test].[dbo].[Test] WHERE TestID = 1 ] IF HExecuteSQLQuery(dsTest,CurrentConnection,hQueryWithoutCorrection,sTest) THEN IF gbDisconnected = True THEN gbDisconnected = False // Info("Connection Re-Established") END RESULT True ELSE gbDisconnected = True HConnectionClose(CurrentConnection) HOpenConnection(CurrentConnection) HChangeConnection("*",CurrentConnection) Info("Connection was lost, try again") RESULT False END30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48633-wd18-reconnecting-ole/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48633-wd18-reconnecting-ole-48638/read.awp23 Oct 2014 23:16:00 ZI just installed sqlServer 2014 express with (32/64bit combo)SQL Server Native Client 11.0 2011.110.2100.60 from microsoft and i…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48633-wd18-reconnecting-ole-48638/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48633-wd18-reconnecting-ole-48638/read.awp[WD18] Reconnecting to OLE dbguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48633-wd18-reconnecting-ole-48635/read.awp23 Oct 2014 21:31:00 ZInstead of the procedure reconnecting us, the query just fails now even when the connection is re-established. HReconnect also d…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48633-wd18-reconnecting-ole-48635/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48633-wd18-reconnecting-ole-48635/read.awp[WD18] Reconnecting to OLE db