For security reasons we want to put our crystal reports report files into a
database table called reports that can be access by people with the correct
permissions.. I know you can store files in a database, but can the crystal
reports viewer handle a file that was read back through the database as a
binary object? thanks!

Without using persistence interfaces, you can always write the report to a
temporary file with restricted access and delete it when you are done.


"Brian Henry" <brianiup[nospam]@adelphia.net> wrote in message
news:(E-Mail Removed)...
> For security reasons we want to put our crystal reports report files into
a
> database table called reports that can be access by people with the
correct
> permissions.. I know you can store files in a database, but can the
crystal
> reports viewer handle a file that was read back through the database as a
> binary object? thanks!
>
>

is there an example of how to store and read binary files in sqlserver
anywhere for vb.net? I am currently searching right now and haven't came
across a good one yet

"Robin Tucker" <(E-Mail Removed)> wrote in
message news:c3sh1s$if4$1$(E-Mail Removed)...
> Without using persistence interfaces, you can always write the report to a
> temporary file with restricted access and delete it when you are done.
>
>
> "Brian Henry" <brianiup[nospam]@adelphia.net> wrote in message
> news:(E-Mail Removed)...
> > For security reasons we want to put our crystal reports report files
into
> a
> > database table called reports that can be access by people with the
> correct
> > permissions.. I know you can store files in a database, but can the
> crystal
> > reports viewer handle a file that was read back through the database as
a
> > binary object? thanks!
> >
> >
>
>

Reading binary files? You can fetch a data blob into a byte array, then
write that array to disk using a stream and visa-versa (read into byte
array, store in blob field). Our software reads then bytes then uses an
ILockBytes interface to eventually (after lots of arsing about) get an
interface to the COM object that was stored in the DB, without having to
write it to disk first.

"Brian Henry" <brian.henry[nospam]@adelphia.net> wrote in message
news:%(E-Mail Removed)...
> is there an example of how to store and read binary files in sqlserver
> anywhere for vb.net? I am currently searching right now and haven't came
> across a good one yet
>
> "Robin Tucker" <(E-Mail Removed)> wrote in
> message news:c3sh1s$if4$1$(E-Mail Removed)...
> > Without using persistence interfaces, you can always write the report to
a
> > temporary file with restricted access and delete it when you are done.
> >
> >
> > "Brian Henry" <brianiup[nospam]@adelphia.net> wrote in message
> > news:(E-Mail Removed)...
> > > For security reasons we want to put our crystal reports report files
> into
> > a
> > > database table called reports that can be access by people with the
> > correct
> > > permissions.. I know you can store files in a database, but can the
> > crystal
> > > reports viewer handle a file that was read back through the database
as
> a
> > > binary object? thanks!
> > >
> > >
> >
> >
>
>