The SQL or DataBase Connectivity Toolkit Seems Slower with New Version of Microsoft AccessPrimary Software: LabVIEW Toolkits>>Enterprise Connectivity ToolsetPrimary Software Version: 3.0 Primary Software Fixed Version: N/A Secondary Software: N/A
Problem: When using the SQL Toolkit or DataBase Connectivity Toolkit to log data to Microsoft Access, there is a memory leak and the program gets slower each time there is a query. Solution: This is likely related to one or more issues with Microsoft's Access ODBC driver. Some of these issues were corrected in a newer version of the driver included with MDAC (Microsoft Data Access Components). Go to Microsoft's website for more information and version updates. Microsoft Web Site The problem may also be related to issues described in the following Microsoft KnowledgBase articles: INFO: MDAC Upgrade Issues with Access ODBC Driver (Q237994) PRB: Performance Loss When Upgrading Jet ODBC Driver (Q168686) Memory Use Climbs with Multiple Recordsets Under a Single Jet Session/Connection (Q247140) FIX: Memory Leak in Jet ODBC Driver with SQL_NUMERIC or SQL_C_BINARY Data (Q273772) You may also be able to improve matters by implementing the Microsoft fix described in: FIX: MS Access ODBC Driver Does Not Recognize DSN MaxBufferSize (Q195473) Related Links: Attachments:
Report Date: 11/06/2000 Last Updated: 12/05/2004 Document ID: 235DHM0W |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
