Hi,
Does Sql reporting services support Bmp BLOB files?
SapnilSapnil, I believe the answer is yes.
You'll need an image control and choose 'Database' as the 'Source' and
the appropriate column name as the 'Value'. Also select the appropriate
MIME type.
Chris
Sapnil wrote:
> Hi,
> Does Sql reporting services support Bmp BLOB files?
> Sapnil|||Having re-read your post, I should clarify that I assume you mean
bitmaps stored in the database as BLOB fields?
If you mean external files then again yes it can, either using a field
containing the url/unc path or some other direct path are expression to
the path.
Chris
Chris McGuigan wrote:
> Sapnil, I believe the answer is yes.
> You'll need an image control and choose 'Database' as the 'Source' and
> the appropriate column name as the 'Value'. Also select the
> appropriate MIME type.
> Chris
> Sapnil wrote:
> > Hi,
> >
> > Does Sql reporting services support Bmp BLOB files?
> >
> > Sapnil|||I tried as you said. But the BMP imgaes are not displayed in the report.
I tried the same with crystal reports and it worked.
"Chris McGuigan" wrote:
> Having re-read your post, I should clarify that I assume you mean
> bitmaps stored in the database as BLOB fields?
> If you mean external files then again yes it can, either using a field
> containing the url/unc path or some other direct path are expression to
> the path.
> Chris
>
> Chris McGuigan wrote:
> > Sapnil, I believe the answer is yes.
> > You'll need an image control and choose 'Database' as the 'Source' and
> > the appropriate column name as the 'Value'. Also select the
> > appropriate MIME type.
> >
> > Chris
> >
> > Sapnil wrote:
> >
> > > Hi,
> > >
> > > Does Sql reporting services support Bmp BLOB files?
> > >
> > > Sapnil
>|||Sapnil,
I've just checked the Sample Report, Product Catalogue. This uses this
feature and works. It shows an image for each stock item and the image
is taken directly from the database. I suspect you've a setting wrong.
I suggest you load and take a look at this sample report. Look up
sample reports in BOL for details.
In the sample the image is inside a rectangle, which may confuse you
when trying to select it. In the properties pane, in the drop-down list
of property names select ProdPhoto.
Chris
Sapnil wrote:
> I tried as you said. But the BMP imgaes are not displayed in the
> report. I tried the same with crystal reports and it worked.
> "Chris McGuigan" wrote:
> > Having re-read your post, I should clarify that I assume you mean
> > bitmaps stored in the database as BLOB fields?
> > If you mean external files then again yes it can, either using a
> > field containing the url/unc path or some other direct path are
> > expression to the path.
> >
> > Chris
> >
> >
> > Chris McGuigan wrote:
> >
> > > Sapnil, I believe the answer is yes.
> > > You'll need an image control and choose 'Database' as the
> > > 'Source' and the appropriate column name as the 'Value'. Also
> > > select the appropriate MIME type.
> > >
> > > Chris
> > >
> > > Sapnil wrote:
> > >
> > > > Hi,
> > > >
> > > > Does Sql reporting services support Bmp BLOB files?
> > > >
> > > > Sapnil
> >
> >|||Chirs,
I have tried the sample product catalog sample report and it works for me too.
But If I am not wrong the images stored in the BLOB fieds are of type GIF
I tried the same thing with the Northwind database, trying to display the
employees on the report, but there seems to be some problem.
Sapnil
"Chris McGuigan" wrote:
> Sapnil,
> I've just checked the Sample Report, Product Catalogue. This uses this
> feature and works. It shows an image for each stock item and the image
> is taken directly from the database. I suspect you've a setting wrong.
> I suggest you load and take a look at this sample report. Look up
> sample reports in BOL for details.
> In the sample the image is inside a rectangle, which may confuse you
> when trying to select it. In the properties pane, in the drop-down list
> of property names select ProdPhoto.
> Chris
>
> Sapnil wrote:
> > I tried as you said. But the BMP imgaes are not displayed in the
> > report. I tried the same with crystal reports and it worked.
> >
> > "Chris McGuigan" wrote:
> >
> > > Having re-read your post, I should clarify that I assume you mean
> > > bitmaps stored in the database as BLOB fields?
> > > If you mean external files then again yes it can, either using a
> > > field containing the url/unc path or some other direct path are
> > > expression to the path.
> > >
> > > Chris
> > >
> > >
> > > Chris McGuigan wrote:
> > >
> > > > Sapnil, I believe the answer is yes.
> > > > You'll need an image control and choose 'Database' as the
> > > > 'Source' and the appropriate column name as the 'Value'. Also
> > > > select the appropriate MIME type.
> > > >
> > > > Chris
> > > >
> > > > Sapnil wrote:
> > > >
> > > > > Hi,
> > > > >
> > > > > Does Sql reporting services support Bmp BLOB files?
> > > > >
> > > > > Sapnil
> > >
> > >
>|||It's MIME type is set to image/bmp, so I assume it's bmp!
I've never actually used Blob fields. So I'm going by the book rather
than experience! Have you tried all the different MIME types against
your data? Are you 100% sure your fields contain bitmaps and not gifs
or jpegs? I guess you are because you've had it working in Crystal, but
it's worth a check!
Regards
Chris
Sapnil wrote:
> Chirs,
> I have tried the sample product catalog sample report and it works
> for me too. But If I am not wrong the images stored in the BLOB
> fieds are of type GIF I tried the same thing with the Northwind
> database, trying to display the employees on the report, but there
> seems to be some problem.
> Sapnil
> "Chris McGuigan" wrote:
> > Sapnil,
> > I've just checked the Sample Report, Product Catalogue. This uses
> > this feature and works. It shows an image for each stock item and
> > the image is taken directly from the database. I suspect you've a
> > setting wrong.
> >
> > I suggest you load and take a look at this sample report. Look up
> > sample reports in BOL for details.
> >
> > In the sample the image is inside a rectangle, which may confuse you
> > when trying to select it. In the properties pane, in the drop-down
> > list of property names select ProdPhoto.
> >
> > Chris
> >
> >
> > Sapnil wrote:
> >
> > > I tried as you said. But the BMP imgaes are not displayed in the
> > > report. I tried the same with crystal reports and it worked.
> > >
> > > "Chris McGuigan" wrote:
> > >
> > > > Having re-read your post, I should clarify that I assume you
> > > > mean bitmaps stored in the database as BLOB fields?
> > > > If you mean external files then again yes it can, either using a
> > > > field containing the url/unc path or some other direct path are
> > > > expression to the path.
> > > >
> > > > Chris
> > > >
> > > >
> > > > Chris McGuigan wrote:
> > > >
> > > > > Sapnil, I believe the answer is yes.
> > > > > You'll need an image control and choose 'Database' as the
> > > > > 'Source' and the appropriate column name as the 'Value'. Also
> > > > > select the appropriate MIME type.
> > > > >
> > > > > Chris
> > > > >
> > > > > Sapnil wrote:
> > > > >
> > > > > > Hi,
> > > > > >
> > > > > > Does Sql reporting services support Bmp BLOB files?
> > > > > >
> > > > > > Sapnil
> > > >
> > > >
> >
> >|||I have tried all MIME types.
And you are right, its working with crystal reports.
Actually I am in the process of evaluating repoting tools.
"Chris McGuigan" wrote:
> It's MIME type is set to image/bmp, so I assume it's bmp!
> I've never actually used Blob fields. So I'm going by the book rather
> than experience! Have you tried all the different MIME types against
> your data? Are you 100% sure your fields contain bitmaps and not gifs
> or jpegs? I guess you are because you've had it working in Crystal, but
> it's worth a check!
> Regards
> Chris
>
> Sapnil wrote:
> > Chirs,
> > I have tried the sample product catalog sample report and it works
> > for me too. But If I am not wrong the images stored in the BLOB
> > fieds are of type GIF I tried the same thing with the Northwind
> > database, trying to display the employees on the report, but there
> > seems to be some problem.
> >
> > Sapnil
> >
> > "Chris McGuigan" wrote:
> >
> > > Sapnil,
> > > I've just checked the Sample Report, Product Catalogue. This uses
> > > this feature and works. It shows an image for each stock item and
> > > the image is taken directly from the database. I suspect you've a
> > > setting wrong.
> > >
> > > I suggest you load and take a look at this sample report. Look up
> > > sample reports in BOL for details.
> > >
> > > In the sample the image is inside a rectangle, which may confuse you
> > > when trying to select it. In the properties pane, in the drop-down
> > > list of property names select ProdPhoto.
> > >
> > > Chris
> > >
> > >
> > > Sapnil wrote:
> > >
> > > > I tried as you said. But the BMP imgaes are not displayed in the
> > > > report. I tried the same with crystal reports and it worked.
> > > >
> > > > "Chris McGuigan" wrote:
> > > >
> > > > > Having re-read your post, I should clarify that I assume you
> > > > > mean bitmaps stored in the database as BLOB fields?
> > > > > If you mean external files then again yes it can, either using a
> > > > > field containing the url/unc path or some other direct path are
> > > > > expression to the path.
> > > > >
> > > > > Chris
> > > > >
> > > > >
> > > > > Chris McGuigan wrote:
> > > > >
> > > > > > Sapnil, I believe the answer is yes.
> > > > > > You'll need an image control and choose 'Database' as the
> > > > > > 'Source' and the appropriate column name as the 'Value'. Also
> > > > > > select the appropriate MIME type.
> > > > > >
> > > > > > Chris
> > > > > >
> > > > > > Sapnil wrote:
> > > > > >
> > > > > > > Hi,
> > > > > > >
> > > > > > > Does Sql reporting services support Bmp BLOB files?
> > > > > > >
> > > > > > > Sapnil
> > > > >
> > > > >
> > >
> > >
>|||Hi Sapnil,
I'm a bit stumped I'm afraid. What exactly are you getting?
In terms of evaluation, I'm an ex-Crystal user who switched to RS last
February and have had little need to revert back since.
That's not to say that there are things Crystal doesn't do better than
RS, but for my environment, RS has many more advantages. I'm playing
with RS2005 now (due to be "launched" early November) and it's looking
good with ReportBuilder filling many of the RS's shortcomings against
Crystal. This is a bit off topic now but if you trawl this newsgroup
you'll see plenty of worthwhile exchanges on the pro's and con's of
various reporting tools.
Obviously this image issue is a problem for you! Are you using SP1 or
SP2?
Chris
Sapnil wrote:
> I have tried all MIME types.
> And you are right, its working with crystal reports.
> Actually I am in the process of evaluating repoting tools.
> "Chris McGuigan" wrote:
> > It's MIME type is set to image/bmp, so I assume it's bmp!
> > I've never actually used Blob fields. So I'm going by the book
> > rather than experience! Have you tried all the different MIME types
> > against your data? Are you 100% sure your fields contain bitmaps
> > and not gifs or jpegs? I guess you are because you've had it
> > working in Crystal, but it's worth a check!
> >
> > Regards
> > Chris
> >
> >
> > Sapnil wrote:
> >
> > > Chirs,
> > > I have tried the sample product catalog sample report and it works
> > > for me too. But If I am not wrong the images stored in the BLOB
> > > fieds are of type GIF I tried the same thing with the Northwind
> > > database, trying to display the employees on the report, but there
> > > seems to be some problem.
> > >
> > > Sapnil
> > >
> > > "Chris McGuigan" wrote:
> > >
> > > > Sapnil,
> > > > I've just checked the Sample Report, Product Catalogue. This
> > > > uses this feature and works. It shows an image for each stock
> > > > item and the image is taken directly from the database. I
> > > > suspect you've a setting wrong.
> > > >
> > > > I suggest you load and take a look at this sample report. Look
> > > > up sample reports in BOL for details.
> > > >
> > > > In the sample the image is inside a rectangle, which may
> > > > confuse you when trying to select it. In the properties pane,
> > > > in the drop-down list of property names select ProdPhoto.
> > > >
> > > > Chris
> > > >
> > > >
> > > > Sapnil wrote:
> > > >
> > > > > I tried as you said. But the BMP imgaes are not displayed in
> > > > > the report. I tried the same with crystal reports and it
> > > > > worked.
> > > > >
> > > > > "Chris McGuigan" wrote:
> > > > >
> > > > > > Having re-read your post, I should clarify that I assume you
> > > > > > mean bitmaps stored in the database as BLOB fields?
> > > > > > If you mean external files then again yes it can, either
> > > > > > using a field containing the url/unc path or some other
> > > > > > direct path are expression to the path.
> > > > > >
> > > > > > Chris
> > > > > >
> > > > > >
> > > > > > Chris McGuigan wrote:
> > > > > >
> > > > > > > Sapnil, I believe the answer is yes.
> > > > > > > You'll need an image control and choose 'Database' as the
> > > > > > > 'Source' and the appropriate column name as the 'Value'.
> > > > > > > Also select the appropriate MIME type.
> > > > > > >
> > > > > > > Chris
> > > > > > >
> > > > > > > Sapnil wrote:
> > > > > > >
> > > > > > > > Hi,
> > > > > > > >
> > > > > > > > Does Sql reporting services support Bmp BLOB files?
> > > > > > > >
> > > > > > > > Sapnil
> > > > > >
> > > > > >
> > > >
> > > >
> >
> >|||I am using SP2
"Chris McGuigan" wrote:
> Hi Sapnil,
> I'm a bit stumped I'm afraid. What exactly are you getting?
> In terms of evaluation, I'm an ex-Crystal user who switched to RS last
> February and have had little need to revert back since.
> That's not to say that there are things Crystal doesn't do better than
> RS, but for my environment, RS has many more advantages. I'm playing
> with RS2005 now (due to be "launched" early November) and it's looking
> good with ReportBuilder filling many of the RS's shortcomings against
> Crystal. This is a bit off topic now but if you trawl this newsgroup
> you'll see plenty of worthwhile exchanges on the pro's and con's of
> various reporting tools.
> Obviously this image issue is a problem for you! Are you using SP1 or
> SP2?
> Chris
>
> Sapnil wrote:
> > I have tried all MIME types.
> > And you are right, its working with crystal reports.
> > Actually I am in the process of evaluating repoting tools.
> >
> > "Chris McGuigan" wrote:
> >
> > > It's MIME type is set to image/bmp, so I assume it's bmp!
> > > I've never actually used Blob fields. So I'm going by the book
> > > rather than experience! Have you tried all the different MIME types
> > > against your data? Are you 100% sure your fields contain bitmaps
> > > and not gifs or jpegs? I guess you are because you've had it
> > > working in Crystal, but it's worth a check!
> > >
> > > Regards
> > > Chris
> > >
> > >
> > > Sapnil wrote:
> > >
> > > > Chirs,
> > > > I have tried the sample product catalog sample report and it works
> > > > for me too. But If I am not wrong the images stored in the BLOB
> > > > fieds are of type GIF I tried the same thing with the Northwind
> > > > database, trying to display the employees on the report, but there
> > > > seems to be some problem.
> > > >
> > > > Sapnil
> > > >
> > > > "Chris McGuigan" wrote:
> > > >
> > > > > Sapnil,
> > > > > I've just checked the Sample Report, Product Catalogue. This
> > > > > uses this feature and works. It shows an image for each stock
> > > > > item and the image is taken directly from the database. I
> > > > > suspect you've a setting wrong.
> > > > >
> > > > > I suggest you load and take a look at this sample report. Look
> > > > > up sample reports in BOL for details.
> > > > >
> > > > > In the sample the image is inside a rectangle, which may
> > > > > confuse you when trying to select it. In the properties pane,
> > > > > in the drop-down list of property names select ProdPhoto.
> > > > >
> > > > > Chris
> > > > >
> > > > >
> > > > > Sapnil wrote:
> > > > >
> > > > > > I tried as you said. But the BMP imgaes are not displayed in
> > > > > > the report. I tried the same with crystal reports and it
> > > > > > worked.
> > > > > >
> > > > > > "Chris McGuigan" wrote:
> > > > > >
> > > > > > > Having re-read your post, I should clarify that I assume you
> > > > > > > mean bitmaps stored in the database as BLOB fields?
> > > > > > > If you mean external files then again yes it can, either
> > > > > > > using a field containing the url/unc path or some other
> > > > > > > direct path are expression to the path.
> > > > > > >
> > > > > > > Chris
> > > > > > >
> > > > > > >
> > > > > > > Chris McGuigan wrote:
> > > > > > >
> > > > > > > > Sapnil, I believe the answer is yes.
> > > > > > > > You'll need an image control and choose 'Database' as the
> > > > > > > > 'Source' and the appropriate column name as the 'Value'.
> > > > > > > > Also select the appropriate MIME type.
> > > > > > > >
> > > > > > > > Chris
> > > > > > > >
> > > > > > > > Sapnil wrote:
> > > > > > > >
> > > > > > > > > Hi,
> > > > > > > > >
> > > > > > > > > Does Sql reporting services support Bmp BLOB files?
> > > > > > > > >
> > > > > > > > > Sapnil
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > >
> > >
>|||What exactly do you get in your image control, have you tried deploying
it? The VS Preview renderer is not the same as the RM renderer.
Maybe you could look at the code around the image control in the sample
report and that on your report for some clues.
Regards
Chris
Sapnil wrote:
> I am using SP2
>
> "Chris McGuigan" wrote:
> > Hi Sapnil,
> > I'm a bit stumped I'm afraid. What exactly are you getting?
> >
> > In terms of evaluation, I'm an ex-Crystal user who switched to RS
> > last February and have had little need to revert back since.
> > That's not to say that there are things Crystal doesn't do better
> > than RS, but for my environment, RS has many more advantages. I'm
> > playing with RS2005 now (due to be "launched" early November) and
> > it's looking good with ReportBuilder filling many of the RS's
> > shortcomings against Crystal. This is a bit off topic now but if
> > you trawl this newsgroup you'll see plenty of worthwhile exchanges
> > on the pro's and con's of various reporting tools.
> >
> > Obviously this image issue is a problem for you! Are you using SP1
> > or SP2?
> >
> > Chris
> >
> >
> >
> > Sapnil wrote:
> >
> > > I have tried all MIME types.
> > > And you are right, its working with crystal reports.
> > > Actually I am in the process of evaluating repoting tools.
> > >
> > > "Chris McGuigan" wrote:
> > >
> > > > It's MIME type is set to image/bmp, so I assume it's bmp!
> > > > I've never actually used Blob fields. So I'm going by the book
> > > > rather than experience! Have you tried all the different MIME
> > > > types against your data? Are you 100% sure your fields contain
> > > > bitmaps and not gifs or jpegs? I guess you are because you've
> > > > had it working in Crystal, but it's worth a check!
> > > >
> > > > Regards
> > > > Chris
> > > >
> > > >
> > > > Sapnil wrote:
> > > >
> > > > > Chirs,
> > > > > I have tried the sample product catalog sample report and it
> > > > > works for me too. But If I am not wrong the images stored in
> > > > > the BLOB fieds are of type GIF I tried the same thing with
> > > > > the Northwind database, trying to display the employees on
> > > > > the report, but there seems to be some problem.
> > > > >
> > > > > Sapnil
> > > > >
> > > > > "Chris McGuigan" wrote:
> > > > >
> > > > > > Sapnil,
> > > > > > I've just checked the Sample Report, Product Catalogue. This
> > > > > > uses this feature and works. It shows an image for each
> > > > > > stock item and the image is taken directly from the
> > > > > > database. I suspect you've a setting wrong.
> > > > > >
> > > > > > I suggest you load and take a look at this sample report.
> > > > > > Look up sample reports in BOL for details.
> > > > > >
> > > > > > In the sample the image is inside a rectangle, which may
> > > > > > confuse you when trying to select it. In the properties
> > > > > > pane, in the drop-down list of property names select
> > > > > > ProdPhoto.
> > > > > >
> > > > > > Chris
> > > > > >
> > > > > >
> > > > > > Sapnil wrote:
> > > > > >
> > > > > > > I tried as you said. But the BMP imgaes are not displayed
> > > > > > > in the report. I tried the same with crystal reports and
> > > > > > > it worked.
> > > > > > >
> > > > > > > "Chris McGuigan" wrote:
> > > > > > >
> > > > > > > > Having re-read your post, I should clarify that I
> > > > > > > > assume you mean bitmaps stored in the database as BLOB
> > > > > > > > fields? If you mean external files then again yes it
> > > > > > > > can, either using a field containing the url/unc path
> > > > > > > > or some other direct path are expression to the path.
> > > > > > > >
> > > > > > > > Chris
> > > > > > > >
> > > > > > > >
> > > > > > > > Chris McGuigan wrote:
> > > > > > > >
> > > > > > > > > Sapnil, I believe the answer is yes.
> > > > > > > > > You'll need an image control and choose 'Database' as
> > > > > > > > > the 'Source' and the appropriate column name as the
> > > > > > > > > 'Value'. Also select the appropriate MIME type.
> > > > > > > > >
> > > > > > > > > Chris
> > > > > > > > >
> > > > > > > > > Sapnil wrote:
> > > > > > > > >
> > > > > > > > > > Hi,
> > > > > > > > > >
> > > > > > > > > > Does Sql reporting services support Bmp BLOB files?
> > > > > > > > > >
> > > > > > > > > > Sapnil
> > > > > > > >
> > > > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> >
> >|||The images are not displayed on the report, instead I get X marks on the
report.
I checked the RDL for the reports and there is no difference
Pretty strange
"Chris McGuigan" wrote:
> What exactly do you get in your image control, have you tried deploying
> it? The VS Preview renderer is not the same as the RM renderer.
> Maybe you could look at the code around the image control in the sample
> report and that on your report for some clues.
> Regards
> Chris
>
> Sapnil wrote:
> > I am using SP2
> >
> >
> > "Chris McGuigan" wrote:
> >
> > > Hi Sapnil,
> > > I'm a bit stumped I'm afraid. What exactly are you getting?
> > >
> > > In terms of evaluation, I'm an ex-Crystal user who switched to RS
> > > last February and have had little need to revert back since.
> > > That's not to say that there are things Crystal doesn't do better
> > > than RS, but for my environment, RS has many more advantages. I'm
> > > playing with RS2005 now (due to be "launched" early November) and
> > > it's looking good with ReportBuilder filling many of the RS's
> > > shortcomings against Crystal. This is a bit off topic now but if
> > > you trawl this newsgroup you'll see plenty of worthwhile exchanges
> > > on the pro's and con's of various reporting tools.
> > >
> > > Obviously this image issue is a problem for you! Are you using SP1
> > > or SP2?
> > >
> > > Chris
> > >
> > >
> > >
> > > Sapnil wrote:
> > >
> > > > I have tried all MIME types.
> > > > And you are right, its working with crystal reports.
> > > > Actually I am in the process of evaluating repoting tools.
> > > >
> > > > "Chris McGuigan" wrote:
> > > >
> > > > > It's MIME type is set to image/bmp, so I assume it's bmp!
> > > > > I've never actually used Blob fields. So I'm going by the book
> > > > > rather than experience! Have you tried all the different MIME
> > > > > types against your data? Are you 100% sure your fields contain
> > > > > bitmaps and not gifs or jpegs? I guess you are because you've
> > > > > had it working in Crystal, but it's worth a check!
> > > > >
> > > > > Regards
> > > > > Chris
> > > > >
> > > > >
> > > > > Sapnil wrote:
> > > > >
> > > > > > Chirs,
> > > > > > I have tried the sample product catalog sample report and it
> > > > > > works for me too. But If I am not wrong the images stored in
> > > > > > the BLOB fieds are of type GIF I tried the same thing with
> > > > > > the Northwind database, trying to display the employees on
> > > > > > the report, but there seems to be some problem.
> > > > > >
> > > > > > Sapnil
> > > > > >
> > > > > > "Chris McGuigan" wrote:
> > > > > >
> > > > > > > Sapnil,
> > > > > > > I've just checked the Sample Report, Product Catalogue. This
> > > > > > > uses this feature and works. It shows an image for each
> > > > > > > stock item and the image is taken directly from the
> > > > > > > database. I suspect you've a setting wrong.
> > > > > > >
> > > > > > > I suggest you load and take a look at this sample report.
> > > > > > > Look up sample reports in BOL for details.
> > > > > > >
> > > > > > > In the sample the image is inside a rectangle, which may
> > > > > > > confuse you when trying to select it. In the properties
> > > > > > > pane, in the drop-down list of property names select
> > > > > > > ProdPhoto.
> > > > > > >
> > > > > > > Chris
> > > > > > >
> > > > > > >
> > > > > > > Sapnil wrote:
> > > > > > >
> > > > > > > > I tried as you said. But the BMP imgaes are not displayed
> > > > > > > > in the report. I tried the same with crystal reports and
> > > > > > > > it worked.
> > > > > > > >
> > > > > > > > "Chris McGuigan" wrote:
> > > > > > > >
> > > > > > > > > Having re-read your post, I should clarify that I
> > > > > > > > > assume you mean bitmaps stored in the database as BLOB
> > > > > > > > > fields? If you mean external files then again yes it
> > > > > > > > > can, either using a field containing the url/unc path
> > > > > > > > > or some other direct path are expression to the path.
> > > > > > > > >
> > > > > > > > > Chris
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Chris McGuigan wrote:
> > > > > > > > >
> > > > > > > > > > Sapnil, I believe the answer is yes.
> > > > > > > > > > You'll need an image control and choose 'Database' as
> > > > > > > > > > the 'Source' and the appropriate column name as the
> > > > > > > > > > 'Value'. Also select the appropriate MIME type.
> > > > > > > > > >
> > > > > > > > > > Chris
> > > > > > > > > >
> > > > > > > > > > Sapnil wrote:
> > > > > > > > > >
> > > > > > > > > > > Hi,
> > > > > > > > > > >
> > > > > > > > > > > Does Sql reporting services support Bmp BLOB files?
> > > > > > > > > > >
> > > > > > > > > > > Sapnil
> > > > > > > > >
> > > > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > >
> > >
>|||The only thing that comes to mind is some minor difference in the way
the bitmap is stored in the DB compared to what Microsoft expects.
It may be worth raising a support incident with Microsoft if you have
an MSDN subscription. It would be a shame for you to decide not to use
RS because of this one glitch. In an enterpirise environment RS is far
better than Crystal, in my view, not to mention a whole lot cheaper if
you already use MS SQL Server.
Chris
Sapnil wrote:
> The images are not displayed on the report, instead I get X marks on
> the report.
> I checked the RDL for the reports and there is no difference
> Pretty strange
> "Chris McGuigan" wrote:
> > What exactly do you get in your image control, have you tried
> > deploying it? The VS Preview renderer is not the same as the RM
> > renderer.
> >
> > Maybe you could look at the code around the image control in the
> > sample report and that on your report for some clues.
> >
> > Regards
> > Chris
> >
> >
> >
> > Sapnil wrote:
> >
> > > I am using SP2
> > >
> > >
> > > "Chris McGuigan" wrote:
> > >
> > > > Hi Sapnil,
> > > > I'm a bit stumped I'm afraid. What exactly are you getting?
> > > >
> > > > In terms of evaluation, I'm an ex-Crystal user who switched to
> > > > RS last February and have had little need to revert back since.
> > > > That's not to say that there are things Crystal doesn't do
> > > > better than RS, but for my environment, RS has many more
> > > > advantages. I'm playing with RS2005 now (due to be "launched"
> > > > early November) and it's looking good with ReportBuilder
> > > > filling many of the RS's shortcomings against Crystal. This is
> > > > a bit off topic now but if you trawl this newsgroup you'll see
> > > > plenty of worthwhile exchanges on the pro's and con's of
> > > > various reporting tools.
> > > >
> > > > Obviously this image issue is a problem for you! Are you using
> > > > SP1 or SP2?
> > > >
> > > > Chris
> > > >
> > > >
> > > >
> > > > Sapnil wrote:
> > > >
> > > > > I have tried all MIME types.
> > > > > And you are right, its working with crystal reports.
> > > > > Actually I am in the process of evaluating repoting tools.
> > > > >
> > > > > "Chris McGuigan" wrote:
> > > > >
> > > > > > It's MIME type is set to image/bmp, so I assume it's bmp!
> > > > > > I've never actually used Blob fields. So I'm going by the
> > > > > > book rather than experience! Have you tried all the
> > > > > > different MIME types against your data? Are you 100% sure
> > > > > > your fields contain bitmaps and not gifs or jpegs? I guess
> > > > > > you are because you've had it working in Crystal, but it's
> > > > > > worth a check!
> > > > > >
> > > > > > Regards
> > > > > > Chris
> > > > > >
> > > > > >
> > > > > > Sapnil wrote:
> > > > > >
> > > > > > > Chirs,
> > > > > > > I have tried the sample product catalog sample report and
> > > > > > > it works for me too. But If I am not wrong the images
> > > > > > > stored in the BLOB fieds are of type GIF I tried the same
> > > > > > > thing with the Northwind database, trying to display the
> > > > > > > employees on the report, but there seems to be some
> > > > > > > problem.
> > > > > > >
> > > > > > > Sapnil
> > > > > > >
> > > > > > > "Chris McGuigan" wrote:
> > > > > > >
> > > > > > > > Sapnil,
> > > > > > > > I've just checked the Sample Report, Product Catalogue.
> > > > > > > > This uses this feature and works. It shows an image for
> > > > > > > > each stock item and the image is taken directly from the
> > > > > > > > database. I suspect you've a setting wrong.
> > > > > > > >
> > > > > > > > I suggest you load and take a look at this sample
> > > > > > > > report. Look up sample reports in BOL for details.
> > > > > > > >
> > > > > > > > In the sample the image is inside a rectangle, which may
> > > > > > > > confuse you when trying to select it. In the properties
> > > > > > > > pane, in the drop-down list of property names select
> > > > > > > > ProdPhoto.
> > > > > > > >
> > > > > > > > Chris
> > > > > > > >
> > > > > > > >
> > > > > > > > Sapnil wrote:
> > > > > > > >
> > > > > > > > > I tried as you said. But the BMP imgaes are not
> > > > > > > > > displayed in the report. I tried the same with
> > > > > > > > > crystal reports and it worked.
> > > > > > > > >
> > > > > > > > > "Chris McGuigan" wrote:
> > > > > > > > >
> > > > > > > > > > Having re-read your post, I should clarify that I
> > > > > > > > > > assume you mean bitmaps stored in the database as
> > > > > > > > > > BLOB fields? If you mean external files then again
> > > > > > > > > > yes it can, either using a field containing the
> > > > > > > > > > url/unc path or some other direct path are
> > > > > > > > > > expression to the path.
> > > > > > > > > >
> > > > > > > > > > Chris
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > Chris McGuigan wrote:
> > > > > > > > > >
> > > > > > > > > > > Sapnil, I believe the answer is yes.
> > > > > > > > > > > You'll need an image control and choose
> > > > > > > > > > > 'Database' as the 'Source' and the appropriate
> > > > > > > > > > > column name as the 'Value'. Also select the
> > > > > > > > > > > appropriate MIME type.
> > > > > > > > > > >
> > > > > > > > > > > Chris
> > > > > > > > > > >
> > > > > > > > > > > Sapnil wrote:
> > > > > > > > > > >
> > > > > > > > > > > > Hi,
> > > > > > > > > > > >
> > > > > > > > > > > > Does Sql reporting services support Bmp BLOB
> > > > > > > > > > > > files?
> > > > > > > > > > > >
> > > > > > > > > > > > Sapnil
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> >
> >|||Hi Chris,
Thankyou very much for you comments
Sapnil
"Chris McGuigan" wrote:
> The only thing that comes to mind is some minor difference in the way
> the bitmap is stored in the DB compared to what Microsoft expects.
> It may be worth raising a support incident with Microsoft if you have
> an MSDN subscription. It would be a shame for you to decide not to use
> RS because of this one glitch. In an enterpirise environment RS is far
> better than Crystal, in my view, not to mention a whole lot cheaper if
> you already use MS SQL Server.
> Chris
>
> Sapnil wrote:
> > The images are not displayed on the report, instead I get X marks on
> > the report.
> > I checked the RDL for the reports and there is no difference
> > Pretty strange
> >
> > "Chris McGuigan" wrote:
> >
> > > What exactly do you get in your image control, have you tried
> > > deploying it? The VS Preview renderer is not the same as the RM
> > > renderer.
> > >
> > > Maybe you could look at the code around the image control in the
> > > sample report and that on your report for some clues.
> > >
> > > Regards
> > > Chris
> > >
> > >
> > >
> > > Sapnil wrote:
> > >
> > > > I am using SP2
> > > >
> > > >
> > > > "Chris McGuigan" wrote:
> > > >
> > > > > Hi Sapnil,
> > > > > I'm a bit stumped I'm afraid. What exactly are you getting?
> > > > >
> > > > > In terms of evaluation, I'm an ex-Crystal user who switched to
> > > > > RS last February and have had little need to revert back since.
> > > > > That's not to say that there are things Crystal doesn't do
> > > > > better than RS, but for my environment, RS has many more
> > > > > advantages. I'm playing with RS2005 now (due to be "launched"
> > > > > early November) and it's looking good with ReportBuilder
> > > > > filling many of the RS's shortcomings against Crystal. This is
> > > > > a bit off topic now but if you trawl this newsgroup you'll see
> > > > > plenty of worthwhile exchanges on the pro's and con's of
> > > > > various reporting tools.
> > > > >
> > > > > Obviously this image issue is a problem for you! Are you using
> > > > > SP1 or SP2?
> > > > >
> > > > > Chris
> > > > >
> > > > >
> > > > >
> > > > > Sapnil wrote:
> > > > >
> > > > > > I have tried all MIME types.
> > > > > > And you are right, its working with crystal reports.
> > > > > > Actually I am in the process of evaluating repoting tools.
> > > > > >
> > > > > > "Chris McGuigan" wrote:
> > > > > >
> > > > > > > It's MIME type is set to image/bmp, so I assume it's bmp!
> > > > > > > I've never actually used Blob fields. So I'm going by the
> > > > > > > book rather than experience! Have you tried all the
> > > > > > > different MIME types against your data? Are you 100% sure
> > > > > > > your fields contain bitmaps and not gifs or jpegs? I guess
> > > > > > > you are because you've had it working in Crystal, but it's
> > > > > > > worth a check!
> > > > > > >
> > > > > > > Regards
> > > > > > > Chris
> > > > > > >
> > > > > > >
> > > > > > > Sapnil wrote:
> > > > > > >
> > > > > > > > Chirs,
> > > > > > > > I have tried the sample product catalog sample report and
> > > > > > > > it works for me too. But If I am not wrong the images
> > > > > > > > stored in the BLOB fieds are of type GIF I tried the same
> > > > > > > > thing with the Northwind database, trying to display the
> > > > > > > > employees on the report, but there seems to be some
> > > > > > > > problem.
> > > > > > > >
> > > > > > > > Sapnil
> > > > > > > >
> > > > > > > > "Chris McGuigan" wrote:
> > > > > > > >
> > > > > > > > > Sapnil,
> > > > > > > > > I've just checked the Sample Report, Product Catalogue.
> > > > > > > > > This uses this feature and works. It shows an image for
> > > > > > > > > each stock item and the image is taken directly from the
> > > > > > > > > database. I suspect you've a setting wrong.
> > > > > > > > >
> > > > > > > > > I suggest you load and take a look at this sample
> > > > > > > > > report. Look up sample reports in BOL for details.
> > > > > > > > >
> > > > > > > > > In the sample the image is inside a rectangle, which may
> > > > > > > > > confuse you when trying to select it. In the properties
> > > > > > > > > pane, in the drop-down list of property names select
> > > > > > > > > ProdPhoto.
> > > > > > > > >
> > > > > > > > > Chris
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Sapnil wrote:
> > > > > > > > >
> > > > > > > > > > I tried as you said. But the BMP imgaes are not
> > > > > > > > > > displayed in the report. I tried the same with
> > > > > > > > > > crystal reports and it worked.
> > > > > > > > > >
> > > > > > > > > > "Chris McGuigan" wrote:
> > > > > > > > > >
> > > > > > > > > > > Having re-read your post, I should clarify that I
> > > > > > > > > > > assume you mean bitmaps stored in the database as
> > > > > > > > > > > BLOB fields? If you mean external files then again
> > > > > > > > > > > yes it can, either using a field containing the
> > > > > > > > > > > url/unc path or some other direct path are
> > > > > > > > > > > expression to the path.
> > > > > > > > > > >
> > > > > > > > > > > Chris
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > Chris McGuigan wrote:
> > > > > > > > > > >
> > > > > > > > > > > > Sapnil, I believe the answer is yes.
> > > > > > > > > > > > You'll need an image control and choose
> > > > > > > > > > > > 'Database' as the 'Source' and the appropriate
> > > > > > > > > > > > column name as the 'Value'. Also select the
> > > > > > > > > > > > appropriate MIME type.
> > > > > > > > > > > >
> > > > > > > > > > > > Chris
> > > > > > > > > > > >
> > > > > > > > > > > > Sapnil wrote:
> > > > > > > > > > > >
> > > > > > > > > > > > > Hi,
> > > > > > > > > > > > >
> > > > > > > > > > > > > Does Sql reporting services support Bmp BLOB
> > > > > > > > > > > > > files?
> > > > > > > > > > > > >
> > > > > > > > > > > > > Sapnil
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > >
> > >
>
Showing posts with label blob. Show all posts
Showing posts with label blob. Show all posts
Monday, March 19, 2012
Saturday, February 25, 2012
Blobs not displayed when printed programatically
Hey folks,
I have a report that I have created. It contains some graphical BLOB fields that are in a database. These blobs were simply dragged and dropped onto the report.
When I preview the report in Crystal Reports the BLOB fields are displayed. When I print the report programatically in VB .net the BLOBs are blank...
Any help would be much apreciated.
ThanksWhat type of image did you use?
Goto support section of this site and see if you find answer
www.BusinessObjects.com
I have a report that I have created. It contains some graphical BLOB fields that are in a database. These blobs were simply dragged and dropped onto the report.
When I preview the report in Crystal Reports the BLOB fields are displayed. When I print the report programatically in VB .net the BLOBs are blank...
Any help would be much apreciated.
ThanksWhat type of image did you use?
Goto support section of this site and see if you find answer
www.BusinessObjects.com
Blobs in SQL Server
We have a blob in one table that is storing pdf files. I need to
write a select query that will grab that column and write those *.pdf
files out to a location on my hard drive. Does anyone know how that
can be done? All suggestions would be greatly appreciated...Connie (csawyer@.rwbaird.com) writes:
I have a very quick sketch for this on
http://www.sommarskog.se/blobload.txt.
>
I have a very quick sketch for this onhttp://www.sommarskog.se/blobload.txt.
>
--
Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Here is some good information that I found in my search to complete
the above task, I am posting as this may help others working with
blobs:
In this article I want to show, how you can copy a single text or
image value into or out of SQL Server with textcopy.exe utility. You
can find this utility in the directory containing the standard SQL
Server EXE files (C:\Mssql\Binn by default for SQL Server 6.5 and C:
\Mssql7\Binn by default for SQL Server 7.0).
write a select query that will grab that column and write those *.pdf
files out to a location on my hard drive. Does anyone know how that
can be done? All suggestions would be greatly appreciated...Connie (csawyer@.rwbaird.com) writes:
Quote:
Originally Posted by
We have a blob in one table that is storing pdf files. I need to
write a select query that will grab that column and write those *.pdf
files out to a location on my hard drive. Does anyone know how that
can be done? All suggestions would be greatly appreciated...
I have a very quick sketch for this on
http://www.sommarskog.se/blobload.txt.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||On Feb 15, 4:26 pm, Erland Sommarskog <esq...@.sommarskog.sewrote:
Quote:
Originally Posted by
Connie (csaw...@.rwbaird.com) writes:
Quote:
Originally Posted by
We have a blob in one table that is storing pdf files. I need to
write a select query that will grab that column and write those *.pdf
files out to a location on my hard drive. Does anyone know how that
can be done? All suggestions would be greatly appreciated...
>
I have a very quick sketch for this onhttp://www.sommarskog.se/blobload.txt.
>
--
Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Here is some good information that I found in my search to complete
the above task, I am posting as this may help others working with
blobs:
In this article I want to show, how you can copy a single text or
image value into or out of SQL Server with textcopy.exe utility. You
can find this utility in the directory containing the standard SQL
Server EXE files (C:\Mssql\Binn by default for SQL Server 6.5 and C:
\Mssql7\Binn by default for SQL Server 7.0).
The Textcopy utility is not described in SQL Server Books Online, but
you can get its description by typing textcopy /? from the command
prompt. This is the description:
Copies a single text or image value into or out of SQL Server. The
value
is a specified text or image 'column' of a single row (specified by
the
"where clause") of the specified 'table'.
If the direction is IN (/I) then the data from the specified 'file' is
copied into SQL Server, replacing the existing text or image value. If
the
direction is OUT (/O) then the text or image value is copied from
SQL Server into the specified 'file', replacing any existing file.
TEXTCOPY [/S [sqlserver]] [/U [login]] [/P [password]]
[/D [database]] [/T table] [/C column] [/W"where clause"]
[/F file] [{/I | /O}] [/K chunksize] [/Z] [/?]
/S sqlserver The SQL Server to connect to. If 'sqlserver' is
not
specified, the local SQL Server is used.
/U login The login to connect with. If 'login' is not
specified,
a trusted connection will be used.
/P password The password for 'login'. If 'password' is not
specified, a NULL password will be used.
/D database The database that contains the table with the
text or
image data. If 'database' is not specified, the
default
database of 'login' is used.
/T table The table that contains the text or image value.
/C column The text or image column of 'table'.
/W "where clause" A complete where clause (including the WHERE
keyword)
that specifies a single row of 'table'.
/F file The file name.
/I Copy text or image value into SQL Server from
'file'.
/O Copy text or image value out of SQL Server into
'file'.
/K chunksize Size of the data transfer buffer in bytes.
Minimum
value is 1024 bytes, default value is 4096 bytes.
/Z Display debug information while running.
/? Display this usage information and exit.
You will be prompted for any required options you did not specify.
You can use the following stored procedure to simplify the using of
textcopy utility:
CREATE PROCEDURE sp_textcopy (
@.srvname varchar (30),
@.login varchar (30),
@.password varchar (30),
@.dbname varchar (30),
@.tbname varchar (30),
@.colname varchar (30),
@.filename varchar (30),
@.whereclause varchar (40),
@.direction char(1))
AS
DECLARE @.exec_str varchar (255)
SELECT @.exec_str =
'textcopy /S ' + @.srvname +
' /U ' + @.login +
' /P ' + @.password +
' /D ' + @.dbname +
' /T ' + @.tbname +
' /C ' + @.colname +
' /W "' + @.whereclause +
'" /F ' + @.filename +
' /' + @.direction
EXEC master..xp_cmdshell @.exec_str
This is the example to copy image into SQL Server database pubs, table
pub_info, column name logo from picture.bmp file where pub_id='0736':
sp_textcopy @.srvname = 'ServerName',
@.login = 'Login',
@.password = 'Password',
@.dbname = 'pubs',
@.tbname = 'pub_info',
@.colname = 'logo',
@.filename = 'c:\picture.bmp',
@.whereclause = " WHERE pub_id='0736' ",
@.direction = 'I'
blob size limit
"jason" <jason@.discussions.microsoft.com> wrote in message
news:21C19525-825F-4DD3-83E6-B257AB500946@.microsoft.com...
> is there a size at which the items just get too big to be practically
> stored
> in blobs?
Not really, but you have to be increasingly careful with blobs as they get
bigger. For instance in client applciations if you can't afford to easilly
store the whole blob in memory, you need to use streaming access to move it
into and out of the database.
Davidis there a size at which the items just get too big to be practically stored
in blobs?|||"jason" <jason@.discussions.microsoft.com> wrote in message
news:21C19525-825F-4DD3-83E6-B257AB500946@.microsoft.com...
> is there a size at which the items just get too big to be practically
> stored
> in blobs?
Not really, but you have to be increasingly careful with blobs as they get
bigger. For instance in client applciations if you can't afford to easilly
store the whole blob in memory, you need to use streaming access to move it
into and out of the database.
David|||Hi Jason,
In SQL 2000 ntext, text, and image data types are capable of holding
extremely large amounts of data (up to 2 GB) in a single value. In SQL
2005, varchar(max), nvarchar(max), varbinary(max) and nvarbinary(max) also
has 2 GB limitation.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Jason,
In SQL 2000 ntext, text, and image data types are capable of holding
extremely large amounts of data (up to 2 GB) in a single value. In SQL
2005, varchar(max), nvarchar(max), varbinary(max) and nvarbinary(max) also
has 2 GB limitation.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
news:21C19525-825F-4DD3-83E6-B257AB500946@.microsoft.com...
> is there a size at which the items just get too big to be practically
> stored
> in blobs?
Not really, but you have to be increasingly careful with blobs as they get
bigger. For instance in client applciations if you can't afford to easilly
store the whole blob in memory, you need to use streaming access to move it
into and out of the database.
Davidis there a size at which the items just get too big to be practically stored
in blobs?|||"jason" <jason@.discussions.microsoft.com> wrote in message
news:21C19525-825F-4DD3-83E6-B257AB500946@.microsoft.com...
> is there a size at which the items just get too big to be practically
> stored
> in blobs?
Not really, but you have to be increasingly careful with blobs as they get
bigger. For instance in client applciations if you can't afford to easilly
store the whole blob in memory, you need to use streaming access to move it
into and out of the database.
David|||Hi Jason,
In SQL 2000 ntext, text, and image data types are capable of holding
extremely large amounts of data (up to 2 GB) in a single value. In SQL
2005, varchar(max), nvarchar(max), varbinary(max) and nvarbinary(max) also
has 2 GB limitation.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Jason,
In SQL 2000 ntext, text, and image data types are capable of holding
extremely large amounts of data (up to 2 GB) in a single value. In SQL
2005, varchar(max), nvarchar(max), varbinary(max) and nvarbinary(max) also
has 2 GB limitation.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
blob size limit
is there a size at which the items just get too big to be practically stored
in blobs?"jason" <jason@.discussions.microsoft.com> wrote in message
news:21C19525-825F-4DD3-83E6-B257AB500946@.microsoft.com...
> is there a size at which the items just get too big to be practically
> stored
> in blobs?
Not really, but you have to be increasingly careful with blobs as they get
bigger. For instance in client applciations if you can't afford to easilly
store the whole blob in memory, you need to use streaming access to move it
into and out of the database.
David|||Hi Jason,
In SQL 2000 ntext, text, and image data types are capable of holding
extremely large amounts of data (up to 2 GB) in a single value. In SQL
2005, varchar(max), nvarchar(max), varbinary(max) and nvarbinary(max) also
has 2 GB limitation.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
in blobs?"jason" <jason@.discussions.microsoft.com> wrote in message
news:21C19525-825F-4DD3-83E6-B257AB500946@.microsoft.com...
> is there a size at which the items just get too big to be practically
> stored
> in blobs?
Not really, but you have to be increasingly careful with blobs as they get
bigger. For instance in client applciations if you can't afford to easilly
store the whole blob in memory, you need to use streaming access to move it
into and out of the database.
David|||Hi Jason,
In SQL 2000 ntext, text, and image data types are capable of holding
extremely large amounts of data (up to 2 GB) in a single value. In SQL
2005, varchar(max), nvarchar(max), varbinary(max) and nvarbinary(max) also
has 2 GB limitation.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
BLOB Removal
I am working on a DOD contract and would like to find out
if there is any software out there that would allow
deletion of a sql blob, like a word document, and then
scrubbing of the disk where the blob had resided.
Currently we are forced to delete the doc, backup the
database, scrub the disk and over write with hex mutliple
times and then restore the database.
Please let me know if there is software available for
this.
Thankyou
I'm not aware of any tools that would alllow you to scrub the disk with the
DB files in place.
There are a few tools that allow you to encrypt data in SQL Server. But I'm
not aware of anything that would scrube the disks.
Brian
"Thom" <anonymous@.discussions.microsoft.com> wrote in message
news:822f01c48530$f253d040$a501280a@.phx.gbl...
> I am working on a DOD contract and would like to find out
> if there is any software out there that would allow
> deletion of a sql blob, like a word document, and then
> scrubbing of the disk where the blob had resided.
> Currently we are forced to delete the doc, backup the
> database, scrub the disk and over write with hex mutliple
> times and then restore the database.
> Please let me know if there is software available for
> this.
> Thankyou
if there is any software out there that would allow
deletion of a sql blob, like a word document, and then
scrubbing of the disk where the blob had resided.
Currently we are forced to delete the doc, backup the
database, scrub the disk and over write with hex mutliple
times and then restore the database.
Please let me know if there is software available for
this.
Thankyou
I'm not aware of any tools that would alllow you to scrub the disk with the
DB files in place.
There are a few tools that allow you to encrypt data in SQL Server. But I'm
not aware of anything that would scrube the disks.
Brian
"Thom" <anonymous@.discussions.microsoft.com> wrote in message
news:822f01c48530$f253d040$a501280a@.phx.gbl...
> I am working on a DOD contract and would like to find out
> if there is any software out there that would allow
> deletion of a sql blob, like a word document, and then
> scrubbing of the disk where the blob had resided.
> Currently we are forced to delete the doc, backup the
> database, scrub the disk and over write with hex mutliple
> times and then restore the database.
> Please let me know if there is software available for
> this.
> Thankyou
BLOB performance SQL 2005 Do's and Don'ts
Hi,
I have a content based site with over a 1000 downloadable word docs
which are currently stored on a server filesystem.
however these are split in muliple folder paths for different clients
and i am trying to find a more efficient way of doing this. i have
been looking into storing the files as blobs in a db rather than
searching on a filename on a file IO etc
in SQL 2000 this was frowned upon as it was so poorly managed but has
this been improved in 2005 or would i be better off using the same
methods i have in place now?
any comments?If you're searching on filenames, why don't you store the filename in the
database?
"km200281" <k.a.mortimer@.gmail.com> wrote in message
news:1147267971.088679.264550@.u72g2000cwu.googlegroups.com...
> Hi,
> I have a content based site with over a 1000 downloadable word docs
> which are currently stored on a server filesystem.
> however these are split in muliple folder paths for different clients
> and i am trying to find a more efficient way of doing this. i have
> been looking into storing the files as blobs in a db rather than
> searching on a filename on a file IO etc
> in SQL 2000 this was frowned upon as it was so poorly managed but has
> this been improved in 2005 or would i be better off using the same
> methods i have in place now?
> any comments?
>|||Hi,
that is what we do now however a large number of updates are done to
the site on a regular basis and this is because we deal with multiple
versions of the same document in different locations its not easy to
manage hence my query regarding the use of BLOBs
I have a content based site with over a 1000 downloadable word docs
which are currently stored on a server filesystem.
however these are split in muliple folder paths for different clients
and i am trying to find a more efficient way of doing this. i have
been looking into storing the files as blobs in a db rather than
searching on a filename on a file IO etc
in SQL 2000 this was frowned upon as it was so poorly managed but has
this been improved in 2005 or would i be better off using the same
methods i have in place now?
any comments?If you're searching on filenames, why don't you store the filename in the
database?
"km200281" <k.a.mortimer@.gmail.com> wrote in message
news:1147267971.088679.264550@.u72g2000cwu.googlegroups.com...
> Hi,
> I have a content based site with over a 1000 downloadable word docs
> which are currently stored on a server filesystem.
> however these are split in muliple folder paths for different clients
> and i am trying to find a more efficient way of doing this. i have
> been looking into storing the files as blobs in a db rather than
> searching on a filename on a file IO etc
> in SQL 2000 this was frowned upon as it was so poorly managed but has
> this been improved in 2005 or would i be better off using the same
> methods i have in place now?
> any comments?
>|||Hi,
that is what we do now however a large number of updates are done to
the site on a regular basis and this is because we deal with multiple
versions of the same document in different locations its not easy to
manage hence my query regarding the use of BLOBs
BLOB or VARBINARY(MAX) as SSIS source.
Hi all,
Can a SSIS package treat a file from a table ( VARBINARY(MAX) or BLOB) as a source for migration ?
Thanks in advance,
DBAnalyst
Sure. The varbinary(max) SQL 2005 data type maps to the SSIS type DT_IMAGE, which is just a bunch of bytes of which the file consists.So what you have at that point is a byte stream, or byte array.
To use those bytes as file source, you could write them to a file in one dataflow and read them in a second dataflow.
Another way to use varbinary(max) data as a "file source" would be to use a script or custom source component (its not that painful) to wrap a StreamReader object arround the SQL byte stream. Using this approach, the varbinary(max) never touches down to disk as an intermediate step.
There are certainly other techniques, but those come to mind.|||Thanks a lot Jaegd.
BLOB or PIPING a Select
I posted this a few months ago, but at the time did not find a simple method
..
I would like to have a select statement output into a single result...
IE
select email from a.client
rather then return as:
user1@.user.com
user2@.user.com
user3@.user.com
I would like:
user1@.user.comuser1@.user.comuser1@.user.com
Basically treating the result as a single row rather then one for each...
anythoughts or ideas? Am I on crack?
Jordyhttp://support.microsoft.com/newsgr...n-us&sloc=en-us
AMB
"Jordy Boss" wrote:
> I posted this a few months ago, but at the time did not find a simple meth
od...
> I would like to have a select statement output into a single result...
> IE
> select email from a.client
> rather then return as:
> user1@.user.com
> user2@.user.com
> user3@.user.com
> I would like:
> user1@.user.comuser1@.user.comuser1@.user.com
> Basically treating the result as a single row rather then one for each...
> anythoughts or ideas? Am I on crack?
> Jordy
..
I would like to have a select statement output into a single result...
IE
select email from a.client
rather then return as:
user1@.user.com
user2@.user.com
user3@.user.com
I would like:
user1@.user.comuser1@.user.comuser1@.user.com
Basically treating the result as a single row rather then one for each...
anythoughts or ideas? Am I on crack?
Jordyhttp://support.microsoft.com/newsgr...n-us&sloc=en-us
AMB
"Jordy Boss" wrote:
> I posted this a few months ago, but at the time did not find a simple meth
od...
> I would like to have a select statement output into a single result...
> IE
> select email from a.client
> rather then return as:
> user1@.user.com
> user2@.user.com
> user3@.user.com
> I would like:
> user1@.user.comuser1@.user.comuser1@.user.com
> Basically treating the result as a single row rather then one for each...
> anythoughts or ideas? Am I on crack?
> Jordy
BLOB Merge Replication
Hi,
I have setup a Merge Replication between a SQL Server 2005 and a SQL Server Mobile using native C++ code in Windows CE 5. Replication of normal data types (nvarchar, ints etc) works great, but when I try to replicate a blob about 1.5 MB the performance is awful. The download phase seems to be quick while the applytime (printed in debugger) when the database on my CE device is updated is about 3 minutes for 1.5MB binary data which is unacceptable since the database gets locked up during the applytime. The BLOB column is defined as image data type which shall hold up to 1GB data. I have tried to disable compression during replication, but it doesnt matter. Does anyone have some experience of using merge replication with blobs in SQL Server Mobile?
My Idea was to use merge replication as a way to transfer CAB-files for installation on the Windows CE 5 device by storing them as BLOB:s, but the bad performance may make it impossible.
Ideas? Anyone?
Best regards
Johan Johansson
I'm appending the debug output from the merge replication of the table containing the 1.5 MB BLOB.
SQLCECA30: Client Agent Log Start --
SQLCECA30: 08/23/2006-16:37:41 CSSCEMerge::SingleRun id=0 hr=0 bread=8027251 bwritten=273 c_urows=0 c_drows=0 s_urows=5 s_drows=0 md_n=0 md_c=0 md_r=0 app=mpsim.exe
SQLCECA30: 08/23/2006-16:37:41 CSSCEMerge::Run totalsynctime=222 uploadtime=371 applytime=217185 id=0 publisher='se-cwo-ddb-1' publication='Software' initialsync=1 bread=8027251 bwritten=273 c_urows=0 c_drows=0 s_urows=5 s_drows=0 loops=1 app=mpsim.exe
About the only thing you can do is to factor out the BLOB itself into a related table. For example, let's say right now you have a table called "Orders" which has 10 columns, one of which is a customer signature (image column in SQL Mobile). Every time any column in the orders table is updated, the whole row is replicated, including the image. It would be more efficient to have an Orders table and a separate OrderSignatures table, related by a foreign key.
Darren
|||
Yes, thank you for the suggestion.
I must say that I'm dissapointed in the performance. I mean 1.5 MB binary data is not alot in these days and it is almost impossible to handle for SQL Server Mobile in a merge replication. Can I expect the same bad performance when I replicate alot of rows (lets say 3000) with more ordinary data (say a few columns with ints and varchar(50)) or is this performance problem only related to dealing with BLOBs?
Johan
|||Johan,
I was thinking about your post some more and it occurs to me that you are trying to solve the problem of automatically downloading CAB files
from the server to the CE5 device. I also frequently have this requirement when a mobile app must be automatically updating. There are some
great samples (they are not native code, but you can get the idea of how to do this) of auto-updating by downloading CABs to the device at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetcomp/html/AutoUpdater.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetcomp/html/AUTD_Functionality_NETCF_WebServices.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetcomp/html/DeploymentPatterns.asp
Regards,
Darren
|||
Thank you Darren,
I will have a look at the documents before I decide how I'm going to implement this.
Best regards
Johan
blob info
I put an image as a blob into database.
When I return it and put it into picturebox can I somehow get it's
information: PictureSize, PictureType(jpg,gif...) ?
HrckoSQL Server can return the image length (DATALENGTH function) but has no
other knowledge of the binary contents. If you need that info, create a
separate column for that data.
Hope this helps.
Dan Guzman
SQL Server MVP
"Hrvoje Voda" <hrvoje.voda@.luatech.com> wrote in message
news:e1nv1n$d2d$1@.ss405.t-com.hr...
>I put an image as a blob into database.
> When I return it and put it into picturebox can I somehow get it's
> information: PictureSize, PictureType(jpg,gif...) ?
> Hrcko
>
When I return it and put it into picturebox can I somehow get it's
information: PictureSize, PictureType(jpg,gif...) ?
HrckoSQL Server can return the image length (DATALENGTH function) but has no
other knowledge of the binary contents. If you need that info, create a
separate column for that data.
Hope this helps.
Dan Guzman
SQL Server MVP
"Hrvoje Voda" <hrvoje.voda@.luatech.com> wrote in message
news:e1nv1n$d2d$1@.ss405.t-com.hr...
>I put an image as a blob into database.
> When I return it and put it into picturebox can I somehow get it's
> information: PictureSize, PictureType(jpg,gif...) ?
> Hrcko
>
blob info
I put an image as a blob into database.
When I return it and put it into picturebox can I somehow get it's
information: PictureSize, PictureType(jpg,gif...) ?
HrckoSQL Server can return the image length (DATALENGTH function) but has no
other knowledge of the binary contents. If you need that info, create a
separate column for that data.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Hrvoje Voda" <hrvoje.voda@.luatech.com> wrote in message
news:e1nv1n$d2d$1@.ss405.t-com.hr...
>I put an image as a blob into database.
> When I return it and put it into picturebox can I somehow get it's
> information: PictureSize, PictureType(jpg,gif...) ?
> Hrcko
>
When I return it and put it into picturebox can I somehow get it's
information: PictureSize, PictureType(jpg,gif...) ?
HrckoSQL Server can return the image length (DATALENGTH function) but has no
other knowledge of the binary contents. If you need that info, create a
separate column for that data.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Hrvoje Voda" <hrvoje.voda@.luatech.com> wrote in message
news:e1nv1n$d2d$1@.ss405.t-com.hr...
>I put an image as a blob into database.
> When I return it and put it into picturebox can I somehow get it's
> information: PictureSize, PictureType(jpg,gif...) ?
> Hrcko
>
BLOB index search
Hi,
I am wondering if I can user SQL server to store Word documents in the BLOB
field and then use Index Server to crawl through those documents (maybe on a
timed basis) to generate a catalog which can be used for web based queries
against. If this can be done then any caveats would also be welcome.
Thanks,
Yes. You can do that via SQL Full Text Search:
http://www.microsoft.com/sql/evaluat...s/fulltext.asp
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Paul" <ancientsiam@.yahoo.com> wrote in message
news:ebl2DFEMFHA.3448@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am wondering if I can user SQL server to store Word documents in the
BLOB
> field and then use Index Server to crawl through those documents (maybe on
a
> timed basis) to generate a catalog which can be used for web based queries
> against. If this can be done then any caveats would also be welcome.
> Thanks,
>
I am wondering if I can user SQL server to store Word documents in the BLOB
field and then use Index Server to crawl through those documents (maybe on a
timed basis) to generate a catalog which can be used for web based queries
against. If this can be done then any caveats would also be welcome.
Thanks,
Yes. You can do that via SQL Full Text Search:
http://www.microsoft.com/sql/evaluat...s/fulltext.asp
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Paul" <ancientsiam@.yahoo.com> wrote in message
news:ebl2DFEMFHA.3448@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am wondering if I can user SQL server to store Word documents in the
BLOB
> field and then use Index Server to crawl through those documents (maybe on
a
> timed basis) to generate a catalog which can be used for web based queries
> against. If this can be done then any caveats would also be welcome.
> Thanks,
>
BLOB index search
Hi,
I am wondering if I can user SQL server to store Word documents in the BLOB
field and then use Index Server to crawl through those documents (maybe on a
timed basis) to generate a catalog which can be used for web based queries
against. If this can be done then any caveats would also be welcome.
Thanks,Yes. You can do that via SQL Full Text Search:
http://www.microsoft.com/sql/evaluation/features/fulltext.asp
--
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Paul" <ancientsiam@.yahoo.com> wrote in message
news:ebl2DFEMFHA.3448@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am wondering if I can user SQL server to store Word documents in the
BLOB
> field and then use Index Server to crawl through those documents (maybe on
a
> timed basis) to generate a catalog which can be used for web based queries
> against. If this can be done then any caveats would also be welcome.
> Thanks,
>
I am wondering if I can user SQL server to store Word documents in the BLOB
field and then use Index Server to crawl through those documents (maybe on a
timed basis) to generate a catalog which can be used for web based queries
against. If this can be done then any caveats would also be welcome.
Thanks,Yes. You can do that via SQL Full Text Search:
http://www.microsoft.com/sql/evaluation/features/fulltext.asp
--
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Paul" <ancientsiam@.yahoo.com> wrote in message
news:ebl2DFEMFHA.3448@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am wondering if I can user SQL server to store Word documents in the
BLOB
> field and then use Index Server to crawl through those documents (maybe on
a
> timed basis) to generate a catalog which can be used for web based queries
> against. If this can be done then any caveats would also be welcome.
> Thanks,
>
BLOB index search
Hi,
I am wondering if I can user SQL server to store Word documents in the BLOB
field and then use Index Server to crawl through those documents (maybe on a
timed basis) to generate a catalog which can be used for web based queries
against. If this can be done then any caveats would also be welcome.
Thanks,Yes. You can do that via SQL Full Text Search:
http://www.microsoft.com/sql/evalua...es/fulltext.asp
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Paul" <ancientsiam@.yahoo.com> wrote in message
news:ebl2DFEMFHA.3448@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am wondering if I can user SQL server to store Word documents in the
BLOB
> field and then use Index Server to crawl through those documents (maybe on
a
> timed basis) to generate a catalog which can be used for web based queries
> against. If this can be done then any caveats would also be welcome.
> Thanks,
>
I am wondering if I can user SQL server to store Word documents in the BLOB
field and then use Index Server to crawl through those documents (maybe on a
timed basis) to generate a catalog which can be used for web based queries
against. If this can be done then any caveats would also be welcome.
Thanks,Yes. You can do that via SQL Full Text Search:
http://www.microsoft.com/sql/evalua...es/fulltext.asp
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Paul" <ancientsiam@.yahoo.com> wrote in message
news:ebl2DFEMFHA.3448@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am wondering if I can user SQL server to store Word documents in the
BLOB
> field and then use Index Server to crawl through those documents (maybe on
a
> timed basis) to generate a catalog which can be used for web based queries
> against. If this can be done then any caveats would also be welcome.
> Thanks,
>
BLOB in T-SQL
Hi,
can anyone help ,me out here with some design consideration reguarding importing of BLOB data to a SQL server 2000 using T-SQL statements?
I want to make an import of some documents which are stored in a Access database, to an Ms SQL server 2000. The documents are stored in the access database as a OLE Object, by now I thought of using the base64String function to convert the data from the access field and write it to the T-SQL statements which will written in a text batch file. And then I apply the SQL Convert function something like:
INSERT INTO testBin VALUES(convert(image,'base64sting_encoded'))
go
Does this work? Is it correct what I am doing?
Thanks.
one rule i remember about handling blob
is that it needs to be on a separate filegroup to avoid
fragmentation
|||
Access OLE Object column data goes directly into image in SQL Server. So I am not sure why you are doing the convert and it may not really produce the correct results. See below links for more details on Access migration:
http://www.microsoft.com/technet/prodtechnol/sql/2000/Deploy/accessmigration.mspx
http://www.microsoft.com/sql/solutions/migration/default.mspx
See the link below for some great information on when to store BLOBs in the database:
http://research.microsoft.com/research/pubs/view.aspx?type=technical+report&id=1089
|||that was also what i have in mind though i hesitate to sayBlob in Tsql
Hi,
I am writing a tsql in which i am saving contents of one table into another using "insert into.. select".
But it doesnt work for Blobs.. what should i do??
can anyone help me on this.
Thank You.Refer to UPDATETEXT/WRITETEXT/READTEXT under BOL.|||ya.. i have tried with writetext and readtext but am not able to get it right with it.
i have to read a blob from a table and insert it into another table.
the code is as follows:
/**************
DECLARE @.ptrval binary(16)
DECLARE @.destval binary(16)
SELECT @.ptrval = TEXTPTR(icon_file)
FROM subject_master where subject_id=1
READTEXT subject_master.icon_file @.ptrval 1 2000
select @.destval = TEXTPTR(icon_file)
FROM subject_master_ver where subject_id=1
Writetext subject_master_ver.icon_file @.destVal @.ptrval
************/
but it doesnt work...
can u help me out with this...
Thank You.
Originally posted by Satya
Refer to UPDATETEXT/WRITETEXT/READTEXT under BOL.|||Have you tried using DTS in this case, if its a regular process then schedule the job to do so.
HTH
Originally posted by swatisk
ya.. i have tried with writetext and readtext but am not able to get it right with it.
i have to read a blob from a table and insert it into another table.
the code is as follows:
/**************
DECLARE @.ptrval binary(16)
DECLARE @.destval binary(16)
SELECT @.ptrval = TEXTPTR(icon_file)
FROM subject_master where subject_id=1
READTEXT subject_master.icon_file @.ptrval 1 2000
select @.destval = TEXTPTR(icon_file)
FROM subject_master_ver where subject_id=1
Writetext subject_master_ver.icon_file @.destVal @.ptrval
************/
but it doesnt work...
can u help me out with this...
Thank You.|||its not a regular process... it is triggered by the user of the system.
i have not used DTS at all.
by the way what is the problem with my code??
the way i am using writetext,readtext is fine??
i am not able to find any example for writing a blob(image) into a blob(image) of a table... not available in the books online.
pls help.
Thank You.
Originally posted by Satya
Have you tried using DTS in this case, if its a regular process then schedule the job to do so.
HTH|||Try this
http://www.motobit.com/help/ScptUtl/sa307.htm
I am writing a tsql in which i am saving contents of one table into another using "insert into.. select".
But it doesnt work for Blobs.. what should i do??
can anyone help me on this.
Thank You.Refer to UPDATETEXT/WRITETEXT/READTEXT under BOL.|||ya.. i have tried with writetext and readtext but am not able to get it right with it.
i have to read a blob from a table and insert it into another table.
the code is as follows:
/**************
DECLARE @.ptrval binary(16)
DECLARE @.destval binary(16)
SELECT @.ptrval = TEXTPTR(icon_file)
FROM subject_master where subject_id=1
READTEXT subject_master.icon_file @.ptrval 1 2000
select @.destval = TEXTPTR(icon_file)
FROM subject_master_ver where subject_id=1
Writetext subject_master_ver.icon_file @.destVal @.ptrval
************/
but it doesnt work...
can u help me out with this...
Thank You.
Originally posted by Satya
Refer to UPDATETEXT/WRITETEXT/READTEXT under BOL.|||Have you tried using DTS in this case, if its a regular process then schedule the job to do so.
HTH
Originally posted by swatisk
ya.. i have tried with writetext and readtext but am not able to get it right with it.
i have to read a blob from a table and insert it into another table.
the code is as follows:
/**************
DECLARE @.ptrval binary(16)
DECLARE @.destval binary(16)
SELECT @.ptrval = TEXTPTR(icon_file)
FROM subject_master where subject_id=1
READTEXT subject_master.icon_file @.ptrval 1 2000
select @.destval = TEXTPTR(icon_file)
FROM subject_master_ver where subject_id=1
Writetext subject_master_ver.icon_file @.destVal @.ptrval
************/
but it doesnt work...
can u help me out with this...
Thank You.|||its not a regular process... it is triggered by the user of the system.
i have not used DTS at all.
by the way what is the problem with my code??
the way i am using writetext,readtext is fine??
i am not able to find any example for writing a blob(image) into a blob(image) of a table... not available in the books online.
pls help.
Thank You.
Originally posted by Satya
Have you tried using DTS in this case, if its a regular process then schedule the job to do so.
HTH|||Try this
http://www.motobit.com/help/ScptUtl/sa307.htm
BLOB fields - questions
Hi,
Ok, I am pretty new to BLOB's on SQL SERVER 200 so I need some answeres.
1. Can BLOB Fields hold .doc and/or .pdf documents?
2. If yes, can the contents of the documents be searchable.
3. If documents are updated do BLOB Fields lengtht change/grow dynamically?
I would apreciate any answers in this matter and if possible examples were I can get a better idea on how to configure the BLOB fieds on my DB and/or documentation regarding BLOB's.
Thank you, Pepe.I am far from an expert in BLOB fields but here is my understanding of them. If there are any other gurus out there I will follow with interest as it is not something I have had cause to use/do yet.
1. Being Binary Large Objects I believe a BLOB field should be able to hold a pointer to a .doc or .pdf file.
2. I don't think you can search on the BLOB field as it is only a pointer to the actuall file. I seem to remember form somewhere though that you may be able to search them if it is full text indexed. (Don't quote me on that though)
3. As the table only stores a pointer to the BLOB the length of the field doesn't change when the file changes.
Sorry can't supply any examples for using or configuring BLOB fields|||If you want to learn more on this topic check the following link:
Brief tutorial on using text, ntext, and image data types (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro03/html/sp03g8.asp)|||Hi,
I need to upload .doc files to a BLOB field.
Does anyone know a way to do this? I guess I could use plain Insert commands from SQL Query Analyzer. Alternately, I want to use VB.NET to create an interface for the user to upload this .docs and to retrieve them.
Thank you and I would appreciate some examples if possible.
Pepe.|||ok, since you're saying whatever the website shows is not enough, here is what i came up with when i needed something similar to store various types of documents.
Ok, I am pretty new to BLOB's on SQL SERVER 200 so I need some answeres.
1. Can BLOB Fields hold .doc and/or .pdf documents?
2. If yes, can the contents of the documents be searchable.
3. If documents are updated do BLOB Fields lengtht change/grow dynamically?
I would apreciate any answers in this matter and if possible examples were I can get a better idea on how to configure the BLOB fieds on my DB and/or documentation regarding BLOB's.
Thank you, Pepe.I am far from an expert in BLOB fields but here is my understanding of them. If there are any other gurus out there I will follow with interest as it is not something I have had cause to use/do yet.
1. Being Binary Large Objects I believe a BLOB field should be able to hold a pointer to a .doc or .pdf file.
2. I don't think you can search on the BLOB field as it is only a pointer to the actuall file. I seem to remember form somewhere though that you may be able to search them if it is full text indexed. (Don't quote me on that though)
3. As the table only stores a pointer to the BLOB the length of the field doesn't change when the file changes.
Sorry can't supply any examples for using or configuring BLOB fields|||If you want to learn more on this topic check the following link:
Brief tutorial on using text, ntext, and image data types (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro03/html/sp03g8.asp)|||Hi,
I need to upload .doc files to a BLOB field.
Does anyone know a way to do this? I guess I could use plain Insert commands from SQL Query Analyzer. Alternately, I want to use VB.NET to create an interface for the user to upload this .docs and to retrieve them.
Thank you and I would appreciate some examples if possible.
Pepe.|||ok, since you're saying whatever the website shows is not enough, here is what i came up with when i needed something similar to store various types of documents.
Blob Fields
Can anyone explain me what is blob fields?A blob is a binary large object data type that allows the storage of things like a picture or text in SQL Server , or a pulsing ball of protoplasm from outer space that has an insatiable hunger for human flesh. :)|||rhigdon: don't talk bad about my mama! :)|||Hehe:D
BLOB Field with vbNewLine Query Help
Hello,
I have a Access form that writes a record when anything is changed. This
record is written to a MEMO field with a vbCrLf after each one. This is
done so when the form is opened, the text box will have each change
written as a New Line.
This MEMO Field is written to a Link Table in SQL 2000.
The data is written like so:
Forms!OrderHeader!Changes = Forms!OrderHeader!Changes & vbCrLf & _
Format(Date) & " Agency Disc. was changed from " & Adisc.OldValue
If I look at the Data in the table, it returns like so:
________________________________________
________________
| Field 1 |Field 2 |
|_______________________________________
_______|________|
11/19/1998 CiC No. was changed from 54241 | 53 |
9/19/1998 CiC No. was changed from 542418 | |
11/28/2004 Line ID 4 Ad ID was changed from 26 | |
11/29/2004 Agency Disc. was changed from 5 | |
________________________________________
_______|________|
The above is simply executing: SELECT [Field 1] FROM tblTest WHERE
[Field 2]=53
I've been asked to create a report based on the LAST change date. In
this case 11/29/2004 (Line 4 in Field 1). My question is: what's the
best way to go through this 197, Line Break blob and come up with a
query to return the last date?
- Somehow use RIGHT() ans go backwards to find the date?
- Somehow find the position of, in this case, the 3rd New Line Character
and then SELECT the next LEFT up to the end of the date ?
I've been dying over this for two days now. Can someone give me a
pointer. Thank you much.Answered in .programming. Please don't multi-post.
http://www.aspfaq.com/
(Reverse address to reply.)
"Jim Lou" <jim@.no_spam_no.com> wrote in message
news:MPG.1c165b5cff12dc6a9896a6@.msnews.microsoft.com...
> Hello,
> I have a Access form that writes a record when anything is changed. This
> record is written to a MEMO field with a vbCrLf after each one. This is
> done so when the form is opened, the text box will have each change
> written as a New Line.
> This MEMO Field is written to a Link Table in SQL 2000.
> The data is written like so:
> Forms!OrderHeader!Changes = Forms!OrderHeader!Changes & vbCrLf & _
> Format(Date) & " Agency Disc. was changed from " & Adisc.OldValue
> If I look at the Data in the table, it returns like so:
> ________________________________________
________________
> | Field 1 |Field 2 |
> |_______________________________________
_______|________|
> 11/19/1998 CiC No. was changed from 54241 | 53 |
> 9/19/1998 CiC No. was changed from 542418 | |
> 11/28/2004 Line ID 4 Ad ID was changed from 26 | |
> 11/29/2004 Agency Disc. was changed from 5 | |
> ________________________________________
_______|________|
> The above is simply executing: SELECT [Field 1] FROM tblTest WHERE
> [Field 2]=53
>
> I've been asked to create a report based on the LAST change date. In
> this case 11/29/2004 (Line 4 in Field 1). My question is: what's the
> best way to go through this 197, Line Break blob and come up with a
> query to return the last date?
> - Somehow use RIGHT() ans go backwards to find the date?
> - Somehow find the position of, in this case, the 3rd New Line Character
> and then SELECT the next LEFT up to the end of the date ?
> I've been dying over this for two days now. Can someone give me a
> pointer. Thank you much.
I have a Access form that writes a record when anything is changed. This
record is written to a MEMO field with a vbCrLf after each one. This is
done so when the form is opened, the text box will have each change
written as a New Line.
This MEMO Field is written to a Link Table in SQL 2000.
The data is written like so:
Forms!OrderHeader!Changes = Forms!OrderHeader!Changes & vbCrLf & _
Format(Date) & " Agency Disc. was changed from " & Adisc.OldValue
If I look at the Data in the table, it returns like so:
________________________________________
________________
| Field 1 |Field 2 |
|_______________________________________
_______|________|
11/19/1998 CiC No. was changed from 54241 | 53 |
9/19/1998 CiC No. was changed from 542418 | |
11/28/2004 Line ID 4 Ad ID was changed from 26 | |
11/29/2004 Agency Disc. was changed from 5 | |
________________________________________
_______|________|
The above is simply executing: SELECT [Field 1] FROM tblTest WHERE
[Field 2]=53
I've been asked to create a report based on the LAST change date. In
this case 11/29/2004 (Line 4 in Field 1). My question is: what's the
best way to go through this 197, Line Break blob and come up with a
query to return the last date?
- Somehow use RIGHT() ans go backwards to find the date?
- Somehow find the position of, in this case, the 3rd New Line Character
and then SELECT the next LEFT up to the end of the date ?
I've been dying over this for two days now. Can someone give me a
pointer. Thank you much.Answered in .programming. Please don't multi-post.
http://www.aspfaq.com/
(Reverse address to reply.)
"Jim Lou" <jim@.no_spam_no.com> wrote in message
news:MPG.1c165b5cff12dc6a9896a6@.msnews.microsoft.com...
> Hello,
> I have a Access form that writes a record when anything is changed. This
> record is written to a MEMO field with a vbCrLf after each one. This is
> done so when the form is opened, the text box will have each change
> written as a New Line.
> This MEMO Field is written to a Link Table in SQL 2000.
> The data is written like so:
> Forms!OrderHeader!Changes = Forms!OrderHeader!Changes & vbCrLf & _
> Format(Date) & " Agency Disc. was changed from " & Adisc.OldValue
> If I look at the Data in the table, it returns like so:
> ________________________________________
________________
> | Field 1 |Field 2 |
> |_______________________________________
_______|________|
> 11/19/1998 CiC No. was changed from 54241 | 53 |
> 9/19/1998 CiC No. was changed from 542418 | |
> 11/28/2004 Line ID 4 Ad ID was changed from 26 | |
> 11/29/2004 Agency Disc. was changed from 5 | |
> ________________________________________
_______|________|
> The above is simply executing: SELECT [Field 1] FROM tblTest WHERE
> [Field 2]=53
>
> I've been asked to create a report based on the LAST change date. In
> this case 11/29/2004 (Line 4 in Field 1). My question is: what's the
> best way to go through this 197, Line Break blob and come up with a
> query to return the last date?
> - Somehow use RIGHT() ans go backwards to find the date?
> - Somehow find the position of, in this case, the 3rd New Line Character
> and then SELECT the next LEFT up to the end of the date ?
> I've been dying over this for two days now. Can someone give me a
> pointer. Thank you much.
Subscribe to:
Posts (Atom)