有多少用户可以打开到Microsoft Access的连接？ [英] how many users can open a connection to Microsoft Access?

问题描述

有多少用户可以打开同时微软Access数据库的连接？
我使用asp.net 4.0来写我的申请。

 ＆LT;添加名称=E_ShopAccessConnectionString的connectionString =供应商= Microsoft.Jet.OLEDB.4.0;数据源= | DataDirectory目录| \\ report.mdb;坚持安全信息= TRUE的providerName =System.Data.OleDb/＆GT;
 

解决方案

Access数据库有256个连接的限制，但在数据库驱动程序每个进程64个连接的限制，并作为IIS是一个单一的过程你限制为64。

如果你细心正确关闭您的连接，命令和数据的读者，这通常是足以让许多用户。每个游客并不需要自己的连接。

您很可能你用完了连接前运行到其他限制。如果您有许多访客，你会发现，Access数据库是根本不够快，你需要更先进的数据库系统。

如果您运行的连接断开了，那很可能是因为您不关闭数据库对象得当，使他们仍保持数据库连接活着他们是垃圾回收，直到

how many users can open a connection to Microsoft Access database simultaneously ? I am using asp.net 4.0 to write my application.

<add name="E_ShopAccessConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\report.mdb;Persist Security Info=True" providerName="System.Data.OleDb"/>

解决方案

The Access database has a limit of 256 connections, but there is a limit of 64 connections per process in the database drivers, and as IIS is a single process your limit is 64.

If you are careful to close your connections, commands and data readers properly, this is usually enough for plenty of users. Each visitor doesn't need a connection of their own.

You are likely to run into other limitations before you run out of connections. If you have many visitors, you will find that the Access database is simply not fast enough, and you need a more advanced database system.

If you are running out of connections, that is most likely because you are not closing database objects properly, so that they are still keeping the database connection alive until they are garbage collected.

这篇关于有多少用户可以打开到Microsoft Access的连接？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！