[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).

Server: Msg 11, Level 16, State 1, Line 0

General network error. Check your network documentation.

SELECT 	T1.EID,T1.ENAME,T1.EFF_DATE,T1.ETCODE, T1.ESTAT,T1.SPCLSTAT,T1.ORIGHRDT,T1.EMTDT,
       	T1.EJCLSS,T1.HDEPT,T1.BENEFIT_ELIGIBLE, T1.PARTFULL,T1.EFTE,T1.ANNBASRT,T1.CURBSPRD,
       	T3.SEX, T3.BIRTHDT, T3.ETH, T3.EDUCLVL, T5.CTZNVISA, T2.JCLASS,T2.P_NBR,T2.ACC_NBR,T2.XOBJECT,
       	T2.BUD_PCT_EFF,T2.BUD_FTE,T2.APPT_BEG_DATE, T2.APPT_END_DATE,T2.FTB,T2.ENCUMBERED_AMT,  
       	T2.MONTHLY_RATE,T2.SUPPLEMENT_TYPE, T4.DEPTNO1,T4.DEPTNO2,T4.DEPTNO3,T4.PROFRANK,T4.TNRESTAT, 
       	T4.TNRESTDT,T4.FCLTYTP,T4.VPIND,T4.VPASSOCI, T4.VPASSTI,T4.DEANIND,T4.DEANASSC,T4.DEANASST,T4.CHAIRIND, 
       	T4.ENDOWIND,T4.HORNIND,T4.RSRCHIND,T4.ADJNCTI,T4.VSTNGIND, T4.EMRTSIND,T4.OTHERIND,T4.DISTPROF,T4.PRMFULDT,
       	T4.PRMASSCD,T4.PRMASSTD,T4.PRMOTHRD  
FROM 	SERVER2.TECH.DBO.TRBASCTB T1, SERVER2.BUD.DBO.BDAPTCTB T2, SERVER2.TECH.DBO.TRBIOCTB T3,
     	SERVER2.TECH.DBO.TRFACCTB T4, SERVER2.TECH.DBO.TRJOBCTB J1, SERVER2.TECH.DBO.TRI9DCTB T5
WHERE 	T1.ORGID = 'TT'
AND T1.ETCODE = 'T'
AND (T1.EID IN 
	(SELECT EID 
	 FROM SERVER2.BUD.DBO.BDAPTCTB T5
         WHERE T5.ORGID = T1.ORGID
         AND T5.EID = T1.EID
         AND T5.ENTITY = T1.ETCODE
         AND T2.FISCAL_YR = '2005'
         AND T5.EID > 0
         AND T5.XOBJECT = '01'
         AND T5.ENCUMBERED_AMT > 0
         AND T5.EFF_DATE = 
		(SELECT MAX(T55.EFF_DATE)
            	 FROM SERVER2.BUD.DBO.BDAPTCTB T55
            	 WHERE T55.ORGID = T5.ORGID
              	 AND T55.FISCAL_YR = T5.FISCAL_YR
              	 AND T55.ENTITY = T5.ENTITY
              	 AND T55.EID = T5.EID
              	 AND T55.ACC_NBR = T5.ACC_NBR
              	 AND T55.P_NBR = T5.P_NBR
              	 AND T55.XOBJECT = T5.XOBJECT
              	 AND T55.CLASS = T5.CLASS
              	 AND T55.EFF_DATE <= GETDATE ()
		)
	)
        OR  (
		(J1.SPCLSTAT = 'F') OR
		(T1.SPCLSTAT = 'F') OR
		(J1.EEOCAT = '02' AND T4.PROFRANK BETWEEN '01' AND '04') OR
		(T1.EJCLSS BETWEEN '040300' AND '040472') OR
		(T2.JCLASS BETWEEN '040300' AND '040472')
	    )
    )
AND T2.ENTITY = T1.ETCODE
AND T2.ORGID = T1.ORGID
AND T2.EID = T1.EID
AND T2.FISCAL_YR = '2005'
AND T2.ENCUMBERED_AMT > 0
AND T3.EID = T1.EID
AND T4.EID = T1.EID
AND T4.ORGID = T1.ORGID
AND J1.ORGID = 'TT'
AND T1.ORGID = J1.ORGID
AND J1.TBLGRPCD = 'THJOB'
AND T1.EJCLSS = J1.JCLASS
AND T1.EID = T5.EID    
AND T1.ORGID = T5.ORGID