?
Solved

MS SQL Server error on loading into blob field

Posted on 2002-07-23
3
Medium Priority
?
287 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses
Course of the Month14 days, 8 hours left to enroll

770 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