Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

MS SQL Server error on loading into blob field

Posted on 2002-07-23
3
Medium Priority
?
288 Views
Last Modified: 2010-04-04
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
Comment
Question by:Skorup
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 1

Expert Comment

by:yk030299
ID: 7176140
listen
0
 
LVL 2

Accepted Solution

by:
mikepj earned 800 total points
ID: 7177712
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
 

Expert Comment

by:CleanupPing
ID: 9343007
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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question