[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


VB.net app using SQL Server

Posted on 2005-05-02
Medium Priority
Last Modified: 2010-04-23
I'm working on a VB.net app that uses SQL Server 2000 as it storage utility.  If I wanted to distribute this application to PC's as a single user application and they(the user) did not have an instance of SQL Server, what would I need to do?   Is there a way to include an "instance" of SQL Server?  

I hope I've explained this well enough...
Question by:tobin46

Assisted Solution

cyberdevil67 earned 320 total points
ID: 13914594
Hi tobin46,

  Look at the MSDE 2000 which is the MS Database Engine for desktops... MS website has all the information as does the MSDN for setting and deploying this with applications to desktops, and is what I would recommend doing.


Accepted Solution

checoo earned 360 total points
ID: 13914792
MSDE is the right product for you.

check out the details at the following location http://www.microsoft.com/sql/msde

register for distribution rights of MSDE at http://www.microsoft.com/sql/msde/howtobuy/redistregister.asp

MSDE FAQ http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp

create MSDE setup project http://support.microsoft.com/default.aspx?scid=kb;en-us;325004
LVL 44

Assisted Solution

Arthur_Wood earned 320 total points
ID: 13916825
in answer to your original question, NO you cannot distribute an 'Instance" of SQL Server.  MSDE is the correct alternative, as it is a FREE desktoip version of SQL Server, so you can load ALL of your stored procedures, and Tables from YOUR instance of full SQL Server, into the local instance of MSDE, and all will be right with the world.


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

1.0 - Introduction Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET). If ever there was a subject full of murkiness and bad decisions, it is this one!   The first problem seems to be that people considering this task of converting…
It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses
Course of the Month18 days, 17 hours left to enroll

834 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