Is sql server needed for run a vb.net windows form solution with Sql database as back end?

Question

0.00/5 (No votes)

See more:

I am using a vb.Net 2010 and sql server 2005.
I want to run a solution that with a windows form to another computer.
There is No centralized server.

I want simple help that is as below.
I simply want a answer yes or no.
If yes then why it is needed and if no then why it is not needed.

Posted 26-Nov-10 4:49am

Neeil

Updated 26-Nov-10 6:41am

JF2015

v2

Add a Solution

Comments

JF2015 26-Nov-10 12:41pm

Edited to improve readability.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

TheyCallMeMrJames · Answer 1 · 2010-11-26T05:03:00

Solution 2

Yes, if you want to use SQL Server 2005, you will need SQL Server running somewhere.

No, if you want to use an MDF, you can get away with the local DB and some extra deployment config you won't need a full SQL Server Deployment.

Cheers.

Posted 26-Nov-10 5:03am

TheyCallMeMrJames

Comments

Neeil 26-Nov-10 11:06am

which types of extra deployment....??

TheyCallMeMrJames 26-Nov-10 16:56pm

For example, make sure you're using a user instance and not tied to an instance of SQL Express. You'll want to take steps (perhaps) to protect/encrypt your connection string. Verify your dependencies to make sure the appropriate DLLs are referenced in your install package and, of course, do a test deployment. Make sure that your MDF is included in the install, and make sure that you have a strategy to update the MDF and/or migrate data to new versions down the road, otherwise you risk overwriting their data.

Member 3425873 9-Mar-11 1:52am

You must atleast have "SQL NATIVE CLIENT" to run sql queries