Webmaster Forum / ASP / Database Access / October 2007

Hi,

I've a couple of asp web pages that pull data from an Excel 2003 spreadsheet
and this works absolutely fine.  However, should I refresh the web page
within 60 seconds or so I get the following error

Provider error '80004005'
Unspecified error

Let a couple of minutes pass before I refresh and the asp can open the Excel
spreadsheet again.

Can anyone help shed light on why this is happening and how to fix it.
Below is my code for opening and closing the Excel file.

Thanks,
Joe

-----------------------------------------------------------------------------------------------------

strConnection = "DBQ=" & Server.MapPath("BUCKETS.xls") & ";
DRIVER={Microsoft Excel Driver (*.xls)};"

Set cn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
cn.open strConnection

rs.close
Set rs = nothing
cn.close
Set cn = nothing