Delay Timeout Error 关注

0
Avatar
Legacy Poster

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.

2 评论

0
Avatar
Susan Chen
版主
评论操作 固定链接

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
Avatar
Legacy Poster
评论操作 固定链接

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.

请先登录再写评论。