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.

Image DataType Default Value

Hi ,

Iam using sqlserver 2005. what default value i can set to image data type.

Thanks

vijay

The Image Datatype is actualy a Binary datatype.

But you can try setting it to 0x00. That does work for VarBinary(max)

Why are you wanting to set a default value?

IIS Logs Max Per Hour

Hi
Being very new to SQL so iam hoping that this will be
easy.
Using a dts package to transfer IIS logs into a SQL
database i would now like to knpw of there is any
resource that gives some idea on the best stats to take
from IIS Logs.
i have create a query that is a count of [c-ip] i would
like to find out what is the max hourly count of [c-ip]
grouped by day the data is very mixed as when log a is
recorded could be 3 a second or not one for a few
seconds ? but generally data is at per second level?

Quote:

Originally posted by Simon Jelinek
Hi
Being very new to SQL so iam hoping that this will be
easy.
Using a dts package to transfer IIS logs into a SQL
database i would now like to knpw of there is any
resource that gives some idea on the best stats to take
from IIS Logs.
i have create a query that is a count of [c-ip] i would
like to find out what is the max hourly count of [c-ip]
grouped by day the data is very mixed as when log a is
recorded could be 3 a second or not one for a few
seconds ? but generally data is at per second level?

Try asking your manager, I hear he is very good at this sort of thing