Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQLServer webservice

Posted on 2004-11-18
3
Medium Priority
?
227 Views
Last Modified: 2010-04-07
Hi there

I will have a VB.NET application running on client PCs that connect to a sql server database that's hosted on the internet (via the hoster's web server). My plan is to use a web service for communication between the VB.NET client and the sql database on the internet. The web service will run on the hoster's web server.

I would like to replace my ADO.NET code with the component's code, with minimum work.

My questions are:
1. Is this do-able?
1. Would it be best to create the webservice myself using ASP.NET/VB.NET (I've worked with it a few months on and off, so know my way around these), or should I get a web service from a third-party?
2. If the answer to the above is 'third-party', what are the best products in terms of usability and cost?

To complete the picture, I should say that this will be a front-end for my admin-users. This is an existing complex interface (written in MSAccess) that I think will I can convert to VB.NET. My standard users will have a different interface created using ASP.NET.

Thanks in advance...
0
Comment
Question by:dalsandhu
2 Comments
 

Author Comment

by:dalsandhu
ID: 12623910
Have found a couple of great resources on web services for sql. After reading these I'm convinced that that I'm going to create a web service to encapsulate the sql data. My VB.NET and ASP.NET apps can then use the same webservice...

http://www.west-wind.com/presentations/dotnetwebservices/DotNetWebServicesData.asp
http://www.ftponline.com/wss/2003_05/magazine/columns/sqlconnection/default.aspx

I think that's my questions answered unless anyone has anything useful to add?
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 12860815
PAQed with points refunded (500)

modulo
Community Support Moderator
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this short web based tutorial, I wanted to show users how they can still use the powers of FrontPage in conjunction with Expression Web 3.  Even though Microsoft eliminated the use of Web components, we can still use them with FrontPage and edit …
Turn A Profile Picture Into A Cartoon Using Photoshop And Illustrator This tutorial will teach you how to make a cartoon style image out of a regular picture. I have tried to keep the tutorial as simple as possible. I used Adobe CS4 for this tuto…
The purpose of this video is to demonstrate how to update a WordPress Site’s version. WordPress releases new versions of its software frequently and it is important to update frequently in order to keep your site secure, and to get new WordPress…
The purpose of this video is to demonstrate how to prevent comment spam on a WordPress Website. This will be demonstrated using a Windows 8 PC. Plugin Akismet will be used. Go to your WordPress login page. This will look like the following: myw…
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question