Access front end creates many "sleeping" connection
- From: Ngo Quang Trung <nqtrung@xxxxxxxxxx>
- Date: Tue, 26 Jul 2005 23:42:40 -0700
I have Access 2003 MDB file as front end to a SQL server database. The
application is using DSN to connect to SQL server. All report and form
use passthrough queries or ODBC linked tables as the record sources.
Some forms / reports have 3 subforms and 2 comboboxes, but the
performance is fine.
When checking the current activities in Enterprise Manager, I realized
that for each client, there is about 5 connection to SQL server. Some of
them are "sleeping", some are "waiting for command".
I have 20 clients using Access front end, and the number of connections
become more than hundred, which slowdown the server.
I also check to make sure that using DSN with connection pooling, but I
do not understand why access automatically create many connection to SQL
server when it is supposed to have only 1? and not "Sleeping" or
"waiting" as I already close the form using this connection.
Thank for any comment, solution for this.
Trung
*** Sent via Developersdex http://www.developersdex.com ***
.
- Prev by Date: Re: Access Front-End
- Next by Date: MS SQL Server/ODBC - Communication Link Failure
- Previous by thread: RE: Remote Connection Problems via Cisco VPN over high speed internet.
- Next by thread: MS SQL Server/ODBC - Communication Link Failure
- Index(es):
Relevant Pages
|
