Client-server LAN programming using SQL database file.

Question

1.00/5 (1 vote)

See more:

Greetings to all experts, Well I have almost spend 2 weeks in codeproject and google for making a client-server program which works over LAN and maintain a ms-access database. All the answers and solutions I got are completely non-understandable and incomplete or non-relevant. So I decided to "Ask directly to all expert" and asking a huge help from experts for my final year project.

Project: Attendance Management Software

Attendance over LAN
Maintain records over MS-Access Database.
Server with full database access
Client with Login,attendance,create,update profiles and some other changes will be made depends upon access level.

Any ideas ?

What I have tried:

Well I know sql commands like INSERT,UPDATE,DELETE and other required feature will be used in SQL VB Project but NEVER worked with MS-Access so Before I start i just wanna clear up concepts

Posted 24-Feb-18 4:08am

Babai JermenKeller Sasmal

Updated 28-Oct-20 22:12pm

v2

Add a Solution

Comments

phil.o 24-Feb-18 10:20am

What help do you need? Where are you stuck?
If you are expecting someone to provide you with a link to a complete solution which would fit all your requirement, I'm afraid it's not likely to happen anytime soon.
You say answers you got are non-understandable. as we do not know which were your questions, nor the answers you got, we are unable to know what knowledge you are missing. As well for "incomplete" and "irrelevant" solutions: the goal of your final year project is for you to show the skills you acquired during your course; expecting to find a complete and relevant solution on the net that you would just copy and present as your own work would not only defeat the purpose of your project, it would be a form a cheating.

Babai JermenKeller Sasmal 24-Feb-18 11:44am

Thank you Phil.o for reading my question. But Maybe Im asking for ideas that how my project takes place. I have build several standalone program with help of codeproject experts but no1 never commented with hard words before like you . I believe also codeproject is share knowlege not opinion. If you can provide some ideas and help others will be grateful instead of placing some lame logic opinion. Thank you have a nice day.

phil.o 24-Feb-18 13:55pm

You missed my point here, and maybe that is because I did not phrase it the right way. So, I will try to rephrase it.
We do not know you; we do not know which knowledge you already have, so it is hard, if not impossible, for us to know what help you need.
Moreover, when you say you made some research and found incomplete or not-understandable solutions, maybe for you that does make sense, but for us this is just an assertion which does not really bring the informations we need to be able to help.
So, sorry if I offended you with my comment, that was not my intent, but it still remains valid.
Have a nice day, too.

Babai JermenKeller Sasmal 24-Feb-18 14:41pm

Thankyou phil.o for again for your precious time. Well allow me to be more specific. I'm working on a software project "Client-Server Attendance Management" since August, 2017. I choose SQL Server and VB.net as tools. I designed database and datatypes. Also designed front-end with VB.net. The application has two parts,
1. Server: Currently server is connected to SQL Server 2008 (Running on VMware, Remote Connection Enabled) and inserting,saving,deleting all data from server application.

Now I just want some ideas about HOW IM GONNA ENABLE TCP/IP to server so CLient program can access data from another guest PC.

I have tested several TCP/IP programs by using sending text messages and sending files. But I dont have any single idea about sending query over NETWORK(LAN) using a client program to server.

Well Solution i need for Enable TCP/IP Networking for Server that allow SQL Query execution and Client for the same.

Sorry if Im bothering you

Maybe some ideas can lead me to make my project done.

3 solutions

Solution 3

Use this connection string, it will work
con.ConnectionString = "Password=passwordOfSSMS;Persist Security Info=True;User ID=LoginNameofSSMS;Initial Catalog=YourDataBaseName;Data Source=computerName

Posted 28-Oct-20 22:13pm

Asad Khan

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)

Richard MacCutchan · Accepted Answer · 2018-02-24T04:18:00

Solution 1

Lots of ideas but there is not enough time or space here to answer such a broad set of questions. If you want to learn MS-Access then go to MSDN, and search from there. For client server, Google will find you lots of samples.

Posted 24-Feb-18 4:18am

Richard MacCutchan

Comments

Babai JermenKeller Sasmal 24-Feb-18 11:45am

Thank you for the idea about MSDN.. Im going in

phil.o · Accepted Answer · 2018-02-24T09:46:00

"HOW IM GONNA ENABLE TCP/IP to server"
Well, for that you first have to make sure that the server is on a LAN segment which is accessible from the stations. If server and clients are on the same subnet (for example, 192.168.0.0/255.255.255.0), they will be able to communicate with each other on the LAN.
Regarding the configuration of the SQL Server instance, there is a control panel called 'SQL Server configuration manager' which allows you to check whether TCP/IP access is enabled; it is enabled by default, so normally you should not have to change anything here.

Then, for the clients to be able to communicate with the server, you have to provide them with a valid connection string. Here is a link which will tell you what connection strings you can use to access a MS SQL Server instance:
SQL Server Connection Strings[^]
It will not give you directly what should be the connection string for your specific instance, but instead inform you on the meaning which the values in this connection string carry, so you can adapt it to your actual configuration.

When you will have determined the proper connection string, then your client application will be able to access the instance of SQL Server. From here, I advise you to search for "SQL Server .NET client application" on google, for example; you will have access to a huge amount of examples and tutorials on the subject.