BUG: Repeatedly Opening and Closing DAO Recordset Increases Connections on SQL Server (240401)
The information in this article applies to:
- Microsoft Visual Basic Enterprise Edition for Windows 5.0
- Microsoft Visual Basic Enterprise Edition for Windows 6.0
This article was previously published under Q240401 SYMPTOMS The number of connections opened on SQL Server increases
indefinitely if a Microsoft Data Access Objects (DAO) recordset is opened and
closed repeatedly when you use DAO version 3.6. This does not happen if you use
DAO version 3.51. You may see this behavior if you use sqlpassthrough in which
the connection string is specified in the OpenDatabase statement.
RESOLUTION Use a Querydef to create the connection instead of creating
the connection in the OpenDatabase statement. STATUSMicrosoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.
This bug was corrected in Microsoft Jet 4.0 Service Pack 4.
For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
239114
How to obtain the latest service pack for the Microsoft Jet 4.0 Database Engine
REFERENCES For more information on SQLPassThrough Queries, see the
following:
Haught, Dan; Jim Ferguson. Microsoft Jet Database Engine Programmer's Guide, Microsoft Press, Second Edition, 1997, pages 397-401.
(c) Microsoft Corporation 1999, All Rights Reserved. Contributions by Margery
Simms, Microsoft Corporation.
Modification Type: | Major | Last Reviewed: | 6/19/2004 |
---|
Keywords: | kbBug kbDatabase kbpending KB240401 |
---|
|