Suggestion about using a database type, VB.Net

Question

0.00/5 (No votes)

See more:

Hi,
My problem is I need to develop a sales application to be used on 5 computers. The database needs to stay on a main computer and other computers should connect with that over LAN.
I donot want to use SQL Server as it is too complicated to give permissions, setting up firewalls etc. for the end user.

Is that any type of database that could serve my purpose, without giving sharing violation error?

Thanks for your helo.

Posted 25-Jan-12 1:05am

Furqan Sehgal

Add a Solution

Comments

Syed Salman Raza Zaidi 25-Jan-12 7:10am

You can alternatively use MySql

Amir Mahfoozi 25-Jan-12 7:54am

SQL Server is not too complicated since its ODBC drivers are installed by default with windows and you just run your application on client side if your Connection String is well written, and not any special configuration needed.

2 solutions

Solution 2

If you have small type application you can use ms access , but I prefer Mysql in place of sql server ....

Posted 25-Jan-12 1:14am

Manoj Kumar Choubey

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)

OriginalGriff · Accepted Answer · 2012-01-25T01:13:00

Solution 1

You could use Access directly, via ODBC, but frankly, it's a bit rubbish when working multiuser.
If you seriously want to have 5 users accessing a single database, then I would go SQL Server every time - the small amount of hassle you would get setting it up is trivial compared to the major hassle you will get trying to use access.
It's really not that complex to get SQL Server running (even the free Express edition) - there are loads of guides which walk you though the process.

MYSql is about as much of a PITA to set up as maintain as well - simply because they both do the same (complicated) job.

Posted 25-Jan-12 1:13am

OriginalGriff

Comments

Furqan Sehgal 25-Jan-12 9:44am

Just tell me one thing, does my client need to attach the database to the instance of server (SQL Server database) after installation or it automatically attached to .\SQLExpress ?

OriginalGriff 25-Jan-12 9:56am

You should create the database on the server as part of your installation, or immediately after.
Have a look at this which attaches a DB: http://www.codeproject.com/Articles/11493/Create-database-during-installation-of-a-NET-appli

Furqan Sehgal 26-Jan-12 10:06am

Thanks a lot..............It helps