pcsoft.us.windevCopyright 2026, PC SOFT29 Jan 2016 17:45:00 Z29 Jan 2016 17:08:00 ZHi everybody, I'm using a service that connects to an external MySQL database, and I'm trying to simulate the loss of this particular connection. The strange thing is that whenever i try to call the function SQLExec to run a simple query (just to check if the connection is still avaliable or not), the service suddenly crashes at that precise spot, without giving SQLExec the possibility to return false.. Is that normal behaviour from it? Here's the code that i actually run: Query is string = "SELECT id, nickname, password FROM users WHERE nickname = '%1' AND password = '%2'" sQuery2 is string= StringBuild(sQuery,usr,psw) b is string="myQuery" ***IF NOT SQLExec(sQuery2,b) THEN SQLInfo(b) ServiceWriteEventLog("Error:"+SQL.MesError) END the *** indicates where the service crashes TIA30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56146-service-crash-sqlexec-without-connection/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56146-service-crash-sqlexec-without-connection-56152/read.awp29 Jan 2016 17:45:00 Zsorry my fault . if it work as same when connect to webservice , sqlexec some error are not return . sqlexec will still retu…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56146-service-crash-sqlexec-without-connection-56152/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56146-service-crash-sqlexec-without-connection-56152/read.awpService crash on SQLExec without connectionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56146-service-crash-sqlexec-without-connection-56151/read.awp29 Jan 2016 17:33:00 ZIf I read well it seems he's talking about a windows service not a webservice. By the way, I don't know how to help.. my post…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56146-service-crash-sqlexec-without-connection-56151/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56146-service-crash-sqlexec-without-connection-56151/read.awpService crash on SQLExec without connectionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56146-service-crash-sqlexec-without-connection-56150/read.awp29 Jan 2016 17:32:00 ZHi CCC2, thank you for your quick answer I agree with you, the handling of errors in webservices could be very tricky... but a…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56146-service-crash-sqlexec-without-connection-56150/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56146-service-crash-sqlexec-without-connection-56150/read.awpService crash on SQLExec without connectionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56146-service-crash-sqlexec-without-connection-56149/read.awp29 Jan 2016 17:26:00 ZHi, if you are using webservice that come with WD then yes it's normal . some error also not catch and return . worse part , …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56146-service-crash-sqlexec-without-connection-56149/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56146-service-crash-sqlexec-without-connection-56149/read.awpService crash on SQLExec without connection