Webmaster Forum / ASP / Database Access / March 2006

Hi.  I am reading a foxpro .dbf file and displaying the results on an
asp page.  The page is working fine, but I did notice something
strange.  After the page is done loading the dbf file appears to be
locked for the next minute.  When I try to open it in FoxPro I get a
"File access is denied" message.  After about a minute from the end of
the page load, the lock goes away and I then can open the dbf in FoxPro
again.  If I hit refresh on the page, I'm rewarded with another 60
second lock...

My code to open the table is like so...

set conDB = Server.CreateObject("ADODB.Connection")
conDB.Open "Driver=Microsoft Visual Foxpro
Driver;UID=;SourceType=DBF;SourceDB=c:\;Exclusive=No;"
set rsDB = Server.CreateObject("ADODB.RecordSet")
strSQL = "select * from tablename"
rsDB.Open strSQL, conDB
...
rsDB.Close
set rsDB = Nothing
set conDB = Nothing

I was hoping the Exclusive=No on the connection string would fix this
problem, however it doesn't seem to have any affect.  Any ideas?

Thanks.