inetserver asp db: I've got a Windows 2000 server running IIS to host a small intranet for my
company. This week my server died on me and I've spent all day building a
new one. Most of the pages use ASP to pull data from FoxPro tables using a
DSN connection. When it page loads, it seems to lock the file it is pulling
data from for several minutes. This is a problem because the source files
are being constantly updated and the program that I use to update the files
keeps returning with an "access denied" error. This didn't happen on the
old server. I luckily had all the pages backed-up so the coding is not
different. I've tried disabling the IIS cache with no luck. I'm using the
lastest MDAC and all the patches/updates for Win 2000 are applied. Any help
would be appreciated as I'm trying to get this back up and running before I
leave on vacation next week.

Thanks,
Brad

[quoted text, click to view]
: company. This week my server died on me and I've spent all day building a
: new one. Most of the pages use ASP to pull data from FoxPro tables using
a
: DSN connection. When it page loads, it seems to lock the file it is
pulling
: data from for several minutes. This is a problem because the source files
: are being constantly updated and the program that I use to update the
files
: keeps returning with an "access denied" error. This didn't happen on the
: old server. I luckily had all the pages backed-up so the coding is not
: different. I've tried disabling the IIS cache with no luck. I'm using
the
: lastest MDAC and all the patches/updates for Win 2000 are applied. Any
help
: would be appreciated as I'm trying to get this back up and running before
I
: leave on vacation next week.

Try using the OLEDB driver:
http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForVisualFoxPro

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp