Writing to a file with VBScript/ASP sometimes gets truncated - why??

[David Bray]

Has anyone encountered (and solved!) this problem?

I have an Access database on a commercial ISP. There is an ASP
page/script which creates a recordset from the database and then
writes a file which can be downloaded via the standard HTML Anchor
element.

This has been working with no problems for months but now we sometimes
see files which are truncated, ie as if not all records in the
recordset were output.

There is a count on the web page saying how many lines were output -
this is the expected value but there are less lines in the file. The
script seems to work perfectly and there are no errors in the IIS log
files. But sometimes the file does not contain the full set of data,
ie a section at the end is missing.

The file is opened with

set oFSystem = Server.CreateOb ject("Scripting .FileSystemObje ct")
set oFile = oFSystem.Create TextFile (strFile, True, False)

all records are written with the oFile.WriteLine method

and is closed with

oFile.Close
set oFile = Nothing
set oFSystem = Nothing

Any ideas?

Thanks
David