Images and complications

This may possibly be the wrong place to ask this question, but never mind. I
am in the process of creating a table to hold images, from which crystal
reports will be used to access the images. I have inserted jpg's into the ne
w
table, but they do not show in the report.
The next logical move was to have a look at the example DB's that ship with
SQL, starting with Pubs. The Pub_info has an image field, so I tried
reporting from that, still no images being displayed in the report.
Next I tried the Employees table in the Northwind db, the photo field is an
images field. These images were displayed with no problems.
Which leads to my actual question/s, does anyone know what the differences
are between the images stored in the northwind database and the pubs
database, are they different file formats (jpeg, gif, etc)?, or are there an
y
other differences?.
As a matter of interest I imported the images from the northwind db into my
new images table and the report read those fine as well.
Any help or pointers much appreciated.I dont see any specific differences in the databases and the images fields.
You might want to explore on the images specifics with Crystal reports side
I suppose. Just a distant shot ...
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
"Martin Barrett" <MartinBarrett@.discussions.microsoft.com> wrote in message
news:B3522CB8-C863-402B-8255-2796CFEB4C2A@.microsoft.com...
> This may possibly be the wrong place to ask this question, but never mind.
I
> am in the process of creating a table to hold images, from which crystal
> reports will be used to access the images. I have inserted jpg's into the
new
> table, but they do not show in the report.
> The next logical move was to have a look at the example DB's that ship
with
> SQL, starting with Pubs. The Pub_info has an image field, so I tried
> reporting from that, still no images being displayed in the report.
> Next I tried the Employees table in the Northwind db, the photo field is
an
> images field. These images were displayed with no problems.
> Which leads to my actual question/s, does anyone know what the differences
> are between the images stored in the northwind database and the pubs
> database, are they different file formats (jpeg, gif, etc)?, or are there
any
> other differences?.
> As a matter of interest I imported the images from the northwind db into
my
> new images table and the report read those fine as well.
> Any help or pointers much appreciated.