Solved

MS SQL Server error on loading into blob field

Posted on 2002-07-23
3
282 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
3 Comments
 
LVL 1

Expert Comment

by:yk030299
ID: 7176140
listen
0
 
LVL 2

Accepted Solution

by:
mikepj earned 200 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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

746 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now