• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 295
  • Last Modified:

MS SQL Server error on loading into blob field

When I'm loading data using LoadFromFile into Blob Field on MSSQL Server database I'm receiving message EOleException "Error occured". I'm using ADO connection through ODBC. Of course no data is written into the field. With other fields of other type, i.e. integer, text I have the same problem. How can I solve this. I use TTable methods edit and insert. When I use MSAccess database such problem is not present, everything works OK.
0
Skorup
Asked:
Skorup
1 Solution
 
yk030299Commented:
listen
0
 
mikepjCommented:
Having the trouble you're having, split that operation into two parts instead of using LoadFromFile.  Use TFileStream and then LoadFromStream(myfilestream).  Then if you have a problem in the loading process, you can see that better.  Also check the size of the field in SQL server.  Check other field properties to ensure there is no reason that SQL Server would be unhappy about what you're loading in.
0
 
CleanupPingCommented:
Skorup:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now