error de ODBC!!!

[mary*]

Hola jyefi nuevamente!!!...te mando la consulta que hago en sql:

Código:

SELECT     TOP 100 PERCENT dbo.E1.CODE, dbo.E1.DIGITO, Msap_1.Medida, Msap_1.Linea, dbo.CAT_TRADE.EQUIPMENT, 
                      dbo.CAT_TRADE.SIDEWALL, MAX(dbo.E1.WEIGHT) AS PPROM, COUNT(dbo.E1.CODE) AS CANTIDAD, MIN(dbo.E1.FECHC) 
                      AS FECHCMIN, dbo.E1.WAREHOUSE
FROM         dbo.E1 LEFT OUTER JOIN
                      dbo.CAT_TRADE ON dbo.E1.DIGITO = dbo.CAT_TRADE.DIGITO LEFT OUTER JOIN
                      [SERV-BCODE].Rast.dbo.opUnic opUnic_1 LEFT OUTER JOIN
                      SERV_MONIT.Monitoreo.dbo.Msap Msap_1 ON opUnicos_1.CodComer = Map_1.CodComer ON 
                      dbo.E1.IDETIQ = opUnic_1.IdEtiq
WHERE     (dbo.E1.FECHC > '2/26/2007 00:00:00') AND (dbo.E1.FECHC < '2/26/2007 23:59:00')
GROUP BY dbo.E1.CODE, dbo.ES1.DIGITO, dbo.ES1.WAREHOUSE, Msap_1.Medida, Msap_1.Linea, 
                      dbo.CAT_TRADE.EQUIPMENT, dbo.CAT_TRADE.SIDEWALL
HAVING      (dbo.E1.CODE > '0') AND (dbo.E1.WAREHOUSE = 1)
ORDER BY dbo.E1.CODE, Masap_1.Medida, Msap_1.Linea

Y en mi aplicacion hago varias consultas de este tipo, esta programada en ASP...ojala con esto me puedas orientar... ....gracias!!!