04:26:29 frmMain LoadJobMaster : -2147467259-[Microsoft][ODBC SQL Server Driver]Communication link failure 04:26:29 *** SELECT * FROM GNS_MessageTxFailLog:ExecRSSMS -2147467259-[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send()). 04:26:29 ExecQuerySMS Reconnected 11/7/2017 4:26:29 12:02:10 *** ConnectDB 3704-Operation is not allowed when the object is closed. 12:02:10 *** SELECT a.JobIdx,a.dtAddedDate,a.sAddedBy,a.nIsNew,a.nStatus,a.sRoomNo,a.sExtNo,a.sGuestName,a.sRemarks,a.sAssignToUser,a.sAssignToDept,a.nJobID,a.nAssignType,a.nCount,a.sCourtesy,b.Description,a.dtSettledDate,a.Duration,a.dtNextExpire,a.sMobileNo,a.nPicture,a.sAddedBy FROM tbJobMaster AS a, tbJobDetail AS b where a.sJobType=b.sJobType AND (a.dtAddedDate between '2017-07-03 00:00:00.000' and '2017-07-05 23:59:59.000' OR ((a.nstatus=1 OR a.nstatus=2 or a.nstatus=4) AND (a.dtAddedDate > '2016-07-11 00:00:00.000'))) and (a.sJobType = '001' OR a.sJobType = '002' OR a.sJobType = '003' OR a.sJobType = '004' OR a.sJobType = '005' OR a.sJobType = '006' OR a.sJobType = '007' OR a.sJobType = '008' OR a.sJobType = '009') UNION ALL SELECT a.JobIdx,a.dtAddedDate,a.sAddedBy,a.nIsNew,a.nStatus,a.sRoomNo,a.sExtNo,a.sGuestName,a.sRemarks,a.sAssignToUser,a.sAssignToDept,a.nJobID,a.nAssignType,a.nCount,a.sCourtesy,b.Description,a.dtSettledDate,a.Duration,a.dtNextExpire,a.sMobileNo,a.nPicture,a.sAddedBy FROM tbJobMasterSchedule AS a, tbJobDetail AS b where a.sJobType=b.sJobType and (a.sAssignToUser = 'SEC' or a.sAssignToDept = 'Security' or a.sAddedBy = 'SEC' or a.sAddedUserDept = 'Security' or sNotifyUsers like '*^SEC^*' ) order by nJobID desc:ExecRS 3709-The connection cannot be used to perform this operation. It is either closed or invalid in this context. 12:02:10 ExecRS Reconnected 11/7/2017 12:02:10 12:02:10 *** ConnectDBSMS 3704-Operation is not allowed when the object is closed. 12:02:10 *** SELECT * FROM GNS_MessageTxFailLog:ExecRSSMS 3709-The connection cannot be used to perform this operation. It is either closed or invalid in this context. 12:02:10 ExecQuerySMS Reconnected 11/7/2017 12:02:10 15:11:02 Program Started at : 11/7/2017 15:11:02 Logged in by:SEC