Delay Timeout Error

Legacy Poster

• 7 de diciembre de 2011 12:27

Hello I ' am new with Seagull. I face the follow error when I am trying to take some fields from the database I work with SQL SERVER 2005.

OLE DB 0x80040E21
IDispatch error #3105

I assume that this error is happening because the lot of time that search the records for the items.
I am wondering if there is some statement in the configuration that can postpone for a while the error .

Thanks in advance.

0

• 

  Susan Chen

  Moderador

  ★ BarTender Hero ★

  • 8 de diciembre de 2011 02:29
  Hi, Nek:
  
  
  Can you elaborate more for us on how do you use Bartender with SQL server 2005? This error is a generic message about an IDispatch error. The description might point out more specific problems.
  
  1)Do you use custom SQL statement in Bartender? Or just get data from SQL server database? Are you using VB or C# and integrate with Bartender?
  
  2)If you use specific SQL statement, can you try the SQL statement on Microsoft SQL2005 Server Management Studio first to see if it work OK first?
  
  
  
  Thanks!

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • 8 de diciembre de 2011 09:38
  Hello Susan ,
  
  yes I use a custom SQL Statement . It is the follow
  
  SELECT SUM(M.QTY1) AS QTY1 , I.CODE2, L.CODE AS ROLON , I.CODE AS MTRL_CODE,I.NAME, M.WHOUSE FROM MTREXTDATA M LEFT JOIN MTRLOT L ON M.MTRLOT=L.MTRLOT LEFT JOIN MTRL I ON L.MTRL = I.MTRL WHERE M.COMPANY=1 AND I.MTRLOTUSE=1 AND I.ISACTIVE=1 AND M.MTRLOT<>0 AND (I.CODE LIKE '%?Артикул%' AND M.WHOUSE = '?Код Склада') AND L.ISACTIVE=1 GROUP BY L.CODE,I.CODE2,I.CODE,I.NAME,M.WHOUSE,I.MTRACN HAVING SUM(M.QTY1)>0 ORDER BY I.CODE, L.CODE
  
  The strange is sometimes it work's ok and some other times not.
  
  Thanks in advance.

  0

Iniciar sesión para dejar un comentario.