Invalid BLOB handle in record buffer Error Message Delphi 4 or 7 with SQL Sever BDE 5.1

[Gogs]

Hi All,

We're in the middle of testing our application with SQL Server and
I'm running into a problem. We have a field of data type BLOB in
Interbase and everything is working fine, however the same field is of
type Text in SQL Server and when I'm trying to read this information
from this field into my object of type stringlist I get an error
returned which says ...


"Invalid BLOB handle in record buffer". I've read numerous articles on
changing the size of field BLOBS To Cache or BLOB SIZE but I still get
the same error. This happens immediately after I try to assign the
field to my object so I don't think it's related to the number of
records in my query. I have tried this in Delphi 4 and Delphi 7 and
the outcome is the same.

The command where this fails is

DetailData.Assign(Query.FieldByName('DETAILDATA'));

Can someone please point me in the right direction as to what I need
to do to get this to work, I simply can't find an alternative...

Best Regards

Gogs...

[Gogs]

Is there anyone that can help me with the issue listed below. Any
assistance at this stage would be most appreciated...

Gogs...

Post by Gogs
Hi All,
We're in the middle of testing our application with SQL Server and
I'm running into a problem. We have a field of data type BLOB in
Interbase and everything is working fine, however the same field is of
type Text in SQL Server and when I'm trying to read this information
from this field into my object of type stringlist I get an error
returned which says ...
"Invalid BLOB handle in record buffer". I've read numerous articles on
changing the size of field BLOBS To Cache or BLOB SIZE but I still get
the same error. This happens immediately after I try to assign the
field to my object so I don't think it's related to the number of
records in my query. I have tried this in Delphi 4 and Delphi 7 and
the outcome is the same.
The command where this fails is
DetailData.Assign(Query.FieldByName('DETAILDATA'));
Can someone please point me in the right direction as to what I need
to do to get this to work, I simply can't find an alternative...
Best Regards
Gogs...

[inputstation]

Heloo Gogsie,

I ran into the same error message. I increase the "BLOB to cache to
20,000 already! still didn't work. Did you find out other solution?

[Bruce Roberts]

Post by inputstation
Heloo Gogsie,
I ran into the same error message. I increase the "BLOB to cache to
20,000 already! still didn't work. Did you find out other solution?

Typically "Invalid BLOB handle in record buffer" indicates damage. You need
to rebuild the table.

[slyde]

I have the same error on all users when I run a report through our in
house Report manager, but not on the SQL server which has the same
settings, apps, etc. Can't be a bad table if it'll run on the server, but
not on the clients. Any ideas?

[Bruce Roberts]

Post by slyde
I have the same error on all users when I run a report through our in
house Report manager, but not on the SQL server which has the same
settings, apps, etc. Can't be a bad table if it'll run on the server, but
not on the clients. Any ideas?

My news server doesn't show your original post so I have no idea what
environment you are operating in. What db? Is your app using the BDE?

[slyde]

I have the same error on all users when I run a report through our in
house Report manager, but not on the SQL server which has the same
settings, apps, etc. Can't be a bad table if it'll run on the server, but
not on the clients. Any ideas?