使用SQL数据库文件的客户端 - 服务器LAN编程。 [英] Client-server LAN programming using SQL database file.

问题描述

向所有专家致以问候，我几乎花了2周的时间在codeproject和google上制作一个客户端服务器程序，该程序可以通过LAN工作并维护一个ms-access数据库。我得到的所有答案和解决方案都完全不可理解，不完整或不相关。所以我决定直接向所有专家询问并向专家寻求我最后一年项目的巨大帮助。



项目：出勤管理软件



通过LAN出席

维护MS-Access数据库的记录。

具有完全数据库访问权限的服务器

具有登录，出勤，创建，更新配置文件和其他一些更改的客户将取决于访问级别。



任何想法？



我尝试了什么：



我知道像INSERT，UPDATE，DELETE和其他所需的sql命令功能将在SQL VB项目中使用但从未与MS-Access一起使用所以在我开始之前我只想清理概念

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

推荐答案

很多想法但是还不够时间或空间在这里回答如此广泛的问题。如果您想学习MS-Access，请转到MSDN，然后从那里搜索。对于客户端服务器，Google会找到很多样本。

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.

IM GONNA如何启用TCP / IP到服务器

那么，首先你需要确保服务器位于可从工作站访问的LAN网段上。如果服务器和客户端位于同一子网上（例如，192.168.0.0 / 255.255.255.0），则它们将能够在LAN上相互通信。

关于SQL Server的配置例如，有一个名为SQL Server配置管理器的控制面板，它允许您检查是否启用了TCP / IP访问;它默认启用，所以通常你不必在这里改变任何东西。



然后，为了让客户能够与服务器通信，你必须为他们提供有效的连接字符串。这是一个链接，它将告诉您可以使用哪些连接字符串来访问MS SQL Server实例：

SQL Server连接字符串 [ ^ ]

它不会直接为您提供特定实例的连接字符串，而是告知您此连接字符串中的值所具有的含义，因此您可以根据实际配置进行调整。



当您确定了正确的连接字符串后，您的客户端应用程序将能够访问SQL Server实例。从这里，我建议你在谷歌上搜索SQL Server .NET客户端应用程序，例如;您将可以访问大量有关该主题的示例和教程。

"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.

这篇关于使用SQL数据库文件的客户端 - 服务器LAN编程。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！