Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 425
  • Last Modified:

Online MSSQL Database Connection vs Web Service?

I normally write web services when working with Windows apps and online MSSQL databases.

Q. Is there another way which is also secure?
0
pointeman
Asked:
pointeman
1 Solution
 
pinaldaveCommented:
If you are using https and encryption you should have no problem.
0
 
rowansmithCommented:
By WebServices I assume you are talking about SOAP?

If so have you had a look at "REST"?  This was coined around 2003 and provides a simpler and (arguably) more secure alternative to Web Services.

http://en.wikipedia.org/wiki/REST
http://msdn.microsoft.com/en-us/netframework/cc950529.aspx
http://it.toolbox.com/blogs/the-soa-blog/the-rest-vs-web-services-debate-continues-11751

-Rowan
0
 
Ted BouskillSenior Software DeveloperCommented:
You can use SSL to connect directly to the SQL database.  Adding web services simply adds moving parts and complexity, it doesn't add security.  In fact, it's one more layer that has to be secured.
0
 
pointemanAuthor Commented:
I'm looking into DiscountASP for SQL connection support.
0
 
pointemanAuthor Commented:
Note: Sorry, I cannot award more than one solution, EE Bug Report: http://www.experts-exchange.com/Community_Support/EE_Bugs/Q_26507120.html?cid=239#a33789239
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now