how to view image data

I have an image column in my table in my SQL 2000 database.
I have inserted a row with binary data for the column.
Is there a simple way I kind view the data with Enterprise Manager?
This is so that I can check that my C++ code that inserted the data is
working?Hi Neil
"neilsolent" wrote:
> I have an image column in my table in my SQL 2000 database.
> I have inserted a row with binary data for the column.
> Is there a simple way I kind view the data with Enterprise Manager?
> This is so that I can check that my C++ code that inserted the data is
> working?
The ability to view as an image is up to the client application, and EM does
not have this ability. If you are going to store many large images it will
bloat the database see
http://databases.aspfaq.com/database/should-i-store-images-in-the-database-or-the-filesystem.html
John|||Thanks for that John.
This is for (max 255) relatively small images (a few K each) so I don't
think bloating will be an issue.
I don't necessarily need to see the data as an image - if I could just
find out the number of bytes that where inserted, that would be good!
At the moment I have a C++ routine to insert data and another one to
read it. Something is not working, but I don't know whether it is the
writing routine or the reading routine, or both !
John Bell wrote:
> Hi Neil
> "neilsolent" wrote:
> > I have an image column in my table in my SQL 2000 database.
> >
> > I have inserted a row with binary data for the column.
> >
> > Is there a simple way I kind view the data with Enterprise Manager?
> >
> > This is so that I can check that my C++ code that inserted the data is
> > working?
> The ability to view as an image is up to the client application, and EM does
> not have this ability. If you are going to store many large images it will
> bloat the database see
> http://databases.aspfaq.com/database/should-i-store-images-in-the-database-or-the-filesystem.html
> John|||Hi Neil
"neilsolent" wrote:
> Thanks for that John.
> This is for (max 255) relatively small images (a few K each) so I don't
> think bloating will be an issue.
> I don't necessarily need to see the data as an image - if I could just
> find out the number of bytes that where inserted, that would be good!
See the datalength function in BOL
SELECT DATALENGTH(ImageCol)
FROM MyTable
> At the moment I have a C++ routine to insert data and another one to
> read it. Something is not working, but I don't know whether it is the
> writing routine or the reading routine, or both !
>
I assume you are using the ADO appendchunk method? If so see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthappchunk.asp
an
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthappendchunkxvc.asp
John