how to upload file to remote sql db ?

[Scott]

Hi,

I need some advice if possible.I have windows form app that needs to copy a
file to a remote sql database. At the moment im exposing 1433 and connecting
with a restricted user.

I have read about SQLXML web services and this seem to me to be a better
connection method i.e user connects to SQLXML webservice and runs SP to
upload file via windows form app.

Is this the "done" way of doing it ?

What other options do I have ?

What is SOAP all about ?

Thanks for any advice.
Scott

 

[Peter Bradley]

I think what you're groping towards is the idea of an n-Tier, distributed
architecture. Unfortunately there's no substitute for reading up about it.
Perhaps you'd like to start here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/secnetlpMSDN.asp

I'll be happy to give you more info, if you need it and think I might be a
suitable person to supply it, either on the list or off it.

HTH


Peter