Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Corey Finley
 Corey Finley
Subject: FoxPro Connection not being released
Thread ID: 22530 Message ID: 22530 # Views: 4 # Ratings: 0
Version: Visual FoxPro 6 Category: ODBC, ADO and OLEDB
Date: Monday, April 21, 2003 4:59:35 PM         

Anyone know why when opening a connection to a FoxPro DB using ADO it would be slow to close it. I can open the FoxPro DB and delete records from a table, close the connection, set it to Nothing, then create new connection, try to Pack and get error that table is in use. I can get it to work if I wait 60 secs between killing connection and executing the Pack query using a new connection.


FoxPro Connection not being released Posted by Corey Finley @ 4/21/2003 4:59:35 PM