Delay Timeout Error
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.
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
-
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 -
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
请先登录再写评论。
评论
2 条评论