SQLServer webservice

Posted on 2004-11-18
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...
Question by:dalsandhu

    Author Comment

    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...

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

    Accepted Solution

    PAQed with points refunded (500)

    Community Support Moderator

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    Suggested Solutions

    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…
    Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
    The purpose of this video is to demonstrate how to create a Printer Friendly PDF on a WordPress Page. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome Screenshot” Google Chrome Extension, and Log…
    The purpose of this video is to demonstrate how to make a WordPress Site faster and smaller in size by cleaning up the database. This will be demonstrated using a Windows 8 PC. Plugin WP Optimize will be used. Go to your WordPress login page. T…

    754 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

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now