集中我的计划 [英] Centralizing my program

问题描述

嗨！我在制作我的程序，排队系统时遇到了麻烦。它将由5个不同的计算机工作站使用。



我的问题是，我是否需要将我正在开发的程序的源代码复制到其他5台电脑？或者我只需要使用安装屏蔽设置程序？我的另一个问题是如何在另外5台计算机上使用单个数据库，系统当前使用的数据库？



我目前正在使用VS2012和MS ACCESS 2007作为我的数据库。谢谢！



我尝试过：

Hi! I'm having trouble on making my program, a queuing system, centralized. It is going to be used by 5 different computer workstations.

My question is, do I need to copy the source code of the program I'm currently developing to the other 5 computers? Or do I only have to setup the program using the install shield? My other problem is how can I use a single database, the one that the system currently uses, on the other 5 computers?

I'm currently using VS2012 and MS ACCESS 2007 as my database. Thanks!

What I have tried:

connString6 = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\IPAdd\share\C:\Users\PCName\folder\database.mdb"

推荐答案

您不需要复制源代码，只需安装程序即可：这就是它的工作！它会在需要运行应用程序的每台计算机上安装您的应用程序及其所依赖的所有文件。



但是......不要使用Access。它不是为多用户访问而设计的，虽然可以这样使用它，但每次我看到它都会产生令人讨厌的问题。

使用基于服务器的数据库，如SQL Server或MySQL相反 - 如果您的代码写得很好，它应该只是将OdbcConnection更改为SqlConnection或MySqlConnection; OdbcCommand到SqlCommand或MySqlCommand;您将需要更改连接字符串，但这应该在配置文件中，因此应该没有问题。

数据库系统需要安装在服务器上，并且数据库本身已添加到引擎中。

You don't need to copy the source code, just the install program should do: that is it's job! It installs your application and all the files it depends on on each computer that needs to run the app.

But ... don't use Access. It's not designed for multiuser access and while it is possible to use it that way, it has given nasty problems every time I've seen it done.
Use a Server based database like SQL Server, or MySQL instead - provided your code is well written, it should be just a case of changing OdbcConnection to SqlConnection or MySqlConnection; OdbcCommand to SqlCommand or MySqlCommand; etc. You will need to change the connection string, but that should be in a configuration file anyway so that should be no problem at all.
The database system will need to be installed on the server, and the database itself added to the engine.

这篇关于集中我的计划的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！