timcof
Tue Sep 02 03:32:49 CDT 2003
Access will serialize those asp requests, because the drivers are not multi-threaded (not meant to be used in a web environment).
However, many people still use ACCESS and still have success with their sites. This group would be better for you as a best possible
scenario when using ACCESS:
microsoft.public.inetserver.asp.db
Thank you. I hope this information is helpful.
Tim Coffey [MSFT]
This posting is provided ?AS IS? with no warranties, and confers no rights. You assume all risk for your use. © 2001 Microsoft
Corporation. All rights reserved.
--------------------
| Content-Class: urn:content-classes:message
| From: "peter" <peter58@mail.hongkong.com>
| Sender: "peter" <peter58@mail.hongkong.com>
| Subject: What is the maximum number of ODBC client connection about Access Databases?
| Date: Sat, 23 Aug 2003 11:50:04 -0700
| Lines: 27
| Message-ID: <018901c369a7$5d8d92c0$a101280a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcNpp12NMYjslS4pTD+mIgeP0Y69Lg==
| Newsgroups: microsoft.public.inetserver.iis
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.inetserver.iis:272130
| NNTP-Posting-Host: TK2MSFTNGXA09 10.40.1.161
| X-Tomcat-NG: microsoft.public.inetserver.iis
|
| What is the maximum number of ODBC client connection
| about Access Databases?
| I have heard from someone saying the maximum connections
| is about 20.
| Is it true?
| I am confusing about what the number 20 is standing for?
|
| For example,
| I have got three access databases (a.mdb, b.mdb, c.mdb).
|
| Which one of the following is right?! #1 or #2 ?
|
| #1. All access database can have 20 ODBC connection
| a.mdb - can have 20 ODBC connections
| b.mdb - can have 20 ODBC connections
| c.mdb - can have 20 ODBC connections
|
| #2. The total number of ODBC connections is 20
| a.mdb - have 10 ODBC connections
| b.mdb - have 3 ODBC connections
| c.mdb - so, it can only have 7 ODBC connections
|
|
| Please help!
| Thank you very much!!!
|
| Peter
|