有关使用数据库类型VB.Net的建议 [英] Suggestion about using a database type, VB.Net

问题描述

我的问题是我需要开发一个可在5台计算机上使用的销售应用程序.该数据库需要保留在主计算机上，其他计算机应通过LAN与该计算机连接.
我不想使用SQL Server，因为它太复杂了，无法为最终用户授予权限，设置防火墙等.

那是任何类型的数据库都可以满足我的目的，而不会给出共享冲突错误吗?

Hi,
My problem is I need to develop a sales application to be used on 5 computers. The database needs to stay on a main computer and other computers should connect with that over LAN.
I donot want to use SQL Server as it is too complicated to give permissions, setting up firewalls etc. for the end user.

Is that any type of database that could serve my purpose, without giving sharing violation error?

Thanks for your helo.

推荐答案

您可以通过ODBC直接使用Access，但是坦率地说，在使用多用户时，这有点麻烦.
如果您真的想让5个用户访问一个数据库，那么我每次都会使用SQL Server-与尝试使用访问权限时遇到的主要麻烦相比，设置它所带来的麻烦很少. /> 运行SQL Server(甚至是免费的Express版本)真的不是那么复杂-有大量的指南可以指导您完成该过程.

MYSql与PITA一样需要设置和维护-仅仅是因为它们都执行相同的(复杂的)工作.

You could use Access directly, via ODBC, but frankly, it''s a bit rubbish when working multiuser.
If you seriously want to have 5 users accessing a single database, then I would go SQL Server every time - the small amount of hassle you would get setting it up is trivial compared to the major hassle you will get trying to use access.
It''s really not that complex to get SQL Server running (even the free Express edition) - there are loads of guides which walk you though the process.

MYSql is about as much of a PITA to set up as maintain as well - simply because they both do the same (complicated) job.

如果您有小型应用程序，则可以使用ms访问权限，但我更喜欢使用Mysql代替sql server....

If you have small type application you can use ms access , but I prefer Mysql in place of sql server ....

这篇关于有关使用数据库类型VB.Net的建议的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！