Multi User Application in VB.NET?

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hi,

I have created one application VS 2008 and SQL SERVER 2005 as backend. In database i have some primary key but they all are auto generated as I have true the Identity option of database in that. Now i would like to make it as multiuser. So for that what should i do? Does i need to change the database for multi user or not? Because i have used in built auto generate option does it require table or row level locking for mulit user environment or not? If it does not require table or row level locks then if i put the EXE of the application on different machines connected on LAN, is it require any change in database connection string? I have putted connection string in app.config file of my application.

Please help me if anyone has knowledge about this....

Thank you

Posted 8-Apr-11 20:20pm

Keyuraashra

Updated 8-Apr-11 21:37pm

Ramalinga Koushik

v2

Add a Solution

2 solutions

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)

Wendelius · Answer 1 · 2011-04-08T21:36:00

Sql Server is a multi user database by nature. Unless you have deliberately put the database into single user mode other users can connect to it.

The connection string defines how to find the Sql Server from your machine. So most likely you have to change the connection string to include the new server name. For info about connection strings, see: http://www.connectionstrings.com/sql-server-2008[^]

Locking is a big area and the part you should take care of in the beginning is transactions. Locking is handled automatically for you. Have a look at this http://en.wikipedia.org/wiki/ACID_transactions[^]. That would give some basic info about transaction handling.

OriginalGriff · Answer 2 · 2011-04-08T20:32:00

You may need to change the connection string, but probably not if they are all connected on the same LAN and in the same domain (MSHOME, or WORKGROUP tend to be the defaults). In any case, this should be in you app.config file, so that should not be a problem.

If you are using Identity fields as your Primary Key then the database will assign them and there should be no need to do any locking when entering new records. You may want to do row locking when you use UPDATE commands though, and consider using transactions if you are inserting or updating a group of records.

Otherwise, MsSQL should handle multi-user without you noticing, until you get to significant numbers of users, that is!

Multi User Application in VB.NET?

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0