Re: Virus scannnig document before saving to database

Kevin, thanks for your replay but that means all my operations would not be
sql server, i.e i can not wrap it all in one sql server transaction. any
other suggestion.

thanks

"Kevin Spencer" wrote:

Save the file to a temp file and scan it. Then insert it from the temp file
to the database.

--
HTH,

Kevin Spencer
Microsoft MVP
Chicken Salad Shooter
http://unclechutney.blogspot.com

A man, a plan, a canal, a palindrome that has.. oh, never mind.

"sameer" <sameer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FB6B0409-F1A7-47DD-8057-E53EFC7C9F35@xxxxxxxxxxxxxxxx
Hi all,
.net framwork 1.1
sql server 2000

I have a vb.net winforms application using webservices\ remoting to
upload documents\ images to the webserver and i am gong to store them in
the
sql server 2000 database and before these are saved to the
database client wants me to scan them for any kind of viruses i.e do a
virus
scan,
how can i do that, have any body done this before. if it was a matter of
just saving those documents staight to the file system of webserver i
could
have invoked the local APIs of the anti virus running on the server but in
this case when i am storing them to the database there might be two way i
can
do the upload
1. i would want to upload them from the cient in chunks like in pieces
of might be 64 K and store them in the database a chunk at a time, so
there
will be multiple rows for the same documents in the database. This mean i
will never be having the whole document in memory on the webserver at any
point? how can i virus scan ? any suggestions??

2. the second option is i take the whole of the document and upload it to
the database in one shot and insert it as a single row in the database.
This
mean at one point in time i will be having the whole document in memory of
the web server, scratching my brain here, can i use it to somehow virus
scan
it , if so how?

please suggest

thanks
sameer

does trend or Symatec offer a webserivce that i can use to scan these
documents OR is there any API from TREND or SYMATEC installed on that
server
that i can use for this purpose.

thanks
sameer




.

Relevant Pages

  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Word 2003/Access2000/SQLSVR
    ... SQL server being where the data is held and this is accessed through a MS ... entire database and that may be say a record for Berkshire. ... "Peter Jamieson" wrote: ... replaced with the first record on the table in use. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: MS Access DAO -> ADO.NET Migration
    ... full SQL Server and I see the logic you explained in a multi user ... allow two users to access the same database file Read/Write at any given ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MS Access DAO -> ADO.NET Migration
    ... For that it is much harder to handle the incremental identifier, ... database but although they have the data, they are not connected at the same ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... SQL Server Management Studio is nowhere to be found on my ...
    (microsoft.public.dotnet.framework.adonet)