Re: how to upload file to remote sql db ?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

"Scott" <scott@> wrote in message
news:ejrwS9rGHHA.3540@xxxxxxxxxxxxxxxxxxxxxxx
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



.