Solved

MS SQL Server error on loading into blob field

Posted on 2002-07-23
3
284 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 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Delphi component that can load a DLL in design time? 8 93
URL for downloading Google Chrome for Win XP 2 235
How to debug For loops? 3 63
Find and Replace Stream with 0s 8 73
The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

726 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