Server - Client Application?

Question

0.00/5 (No votes)

See more:

Hi,

I have One Vb.Net Application, It Use M. S. Access 2003 Database. Currently It Run Perfactly on Single PC.

I want to convert said app. into Server - Client Application.

My Basic Question is, How can we do that . . . . ?

I tried to refrence from this website.
http://vb.net-informations.com/communications/vb.net_chat_server.htm

This is basic Chat App. I want logic and some basic coding idea for following :-
I got All Logic but I am New to Socket of vb.net and access
( Client - Server ).

Can you Guide (With Example Code) for
(1) Connection,
(2) Access Database ( Like Insert, Update and Delete ).
(3) Fetching Data ( Fill Datagrid with data from Server into Client )

Sorry but I am not Understand How to Code and ask same again.

Thanks

Posted 2-Sep-11 8:57am

s1a2b3

Updated 3-Sep-11 22:01pm

v5

Add a Solution

Comments

Bert Mitton 2-Sep-11 15:01pm

Are you committed to MS Access 2003? If not, I suggest switching to SQL Server.

s1a2b3 3-Sep-11 2:06am

Commited to MS Access 2003, :(

3 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)

Abhinav S · Accepted Answer · 2011-09-02T09:00:00

Solution 1

Steps
Step 1) You need to host the database in central server / location and allow client programs to access it.
Step 2) You will need to make sure all clients have network access to this location.
Step 3) To do this, you will need to setup a database connection, say an ODBC setup, on every client
Step 4) You will need to install the client program (VB.Net program) on every client.

Search on the internet. You should be able to locate a good number of articles / samples / tutorials on this type of setup.

Posted 2-Sep-11 9:00am

Abhinav S

Comments

Wendelius 2-Sep-11 15:09pm

Exactly, 5'd :)

Abhinav S 3-Sep-11 0:23am

Thank you Mika.

Sergey Alexandrovich Kryukov 2-Sep-11 15:35pm

Right, a 5.
--SA

Abhinav S 3-Sep-11 0:23am

Thanks SA.

RaviRanjanKr 2-Sep-11 15:37pm

My 5+

Abhinav S 3-Sep-11 0:24am

Thanks Ravi.

s1a2b3 3-Sep-11 2:09am

I Understand the Logic of Server-Client.
Have you any Good Tutorial as you suggest or Sample Code?
I also Try to find out my self, If find one the share it here. Thanks

Wendelius · Accepted Answer · 2011-09-02T09:08:00

Solution 2

To add to Abhinav's answer, since this is an Access project, the client needs to have direct access to the database files. This means that you most likely have to share the folder where the files are located.

For the future. If you plan to have more clients and you want to achieve more secure and robust environment, I'd suggest that you would have a look at SQL Server Express Edition: http://www.microsoft.com/sqlserver/en/us/editions/express.aspx[^]. Migrating to SQL Server at this point could be well worth the time for the future.

Posted 2-Sep-11 9:08am

Wendelius

Comments

RaviRanjanKr 2-Sep-11 15:38pm

Nice suggestion. My 5+

Wendelius 2-Sep-11 15:40pm

Thanks :)

Abhinav S 3-Sep-11 0:24am

Good point about direct access. 5.

s1a2b3 3-Sep-11 2:34am

I share Icon file of App. with Clients but App. Stuck on Splash Screen without showing error. I have to share the folder wher app. installed ? I also use registry to license, Is it Possible to Cause that Bug coz Registry not avil in client ?

Tejas Vaishnav · Accepted Answer · 2011-09-02T20:59:00

What Abhinav and Mika says its good...

But you can try also a webservice refrance to your client side application to communicate with server..

1) That service will able to perform server side database access to perform your database operation.
2) Install or run that webservice over your server.
3) from the client computer you need only a webrefrance to access that service and its method for what you need to perform

References:-
1) http://msdn.microsoft.com/en-us/library/ms973829.aspx[^]
2) How to consume webservice in desktop application..?[^]
3) http://stackoverflow.com/questions/621440/calling-asp-net-web-service-from-c-application[^]

Server - Client Application?

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us