Board index » delphi » EDBCLIENT: Invalid blob handle in record buffer (DbExpress, D2006)
willemvandevis
Delphi Developer |
EDBCLIENT: Invalid blob handle in record buffer (DbExpress, D2006)2008-02-21 10:12:44 PM delphi36 Hi, My program runs at about 200 sites. At a couple of them, I keep getting this error "Invalid blob handle in record buffer". This error occurs just now and then, a couple of times per day, but afterwards, the contents of TEXT fields may get mixed up with those of other records. Of course, this causes serious problems. Setup: Delphi 2006, DbExpress TClientdataset, corelab driver, MS SQL 2005 standard. it is basically one table with about 8 TEXT fields of 100 fields total, 2000 records. Changing to varchar(max) does not help, I presume the problem is on the client, not on the server. About 10 simulteanous users. -->I can't reproduce this in a controlled situation. -->I do not know when EXACTLY the error occurs, e.g. what the user is doing and which method of the clientdataset is begin invoked. it is a large system. I am trying to find out by adding extra logging now. I'm looking for pointers in the right direction or anyone who has experienced the same problem. I have found some results on Google but they're all about a known (Nested dataset) bug in Delphi 7 which should be solved. Thanks for any reaction. Willem. |