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/de...cnetlpMSDN.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:ej**************@TK2MSFTNGP02.phx.gbl...

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