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

MSSQL 2005 and writing to blobs

Hi,

I have an app I wrote in D2005  that uses an MSSQL 2005 server for the backend. The column I'm trying to save data to as a blob is a varbinary column.

I'm taking an open file in an editor saving it to a memory stream and then attempting to write it to a blob. Everything is fine until I get to here

tblobfield(tb_org_mast.FieldByName('org_dat')).LoadFromStream(ms);

Then I get an error that says the field is not blob.

What's wrong?

Thanks,
Greg
0
Mrgregoman
Asked:
Mrgregoman
1 Solution
 
mokuleCommented:
Hi,
define image column not varbinary
0
 
MrgregomanAuthor Commented:
OK, that worked. Why does Varbinary not work?
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

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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