Provider error "80004005" with Excel

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

Re: Provider error "80004005" with Excel

Found the answer at the following KB.

http://support.microsoft.com/kb/q195951/

Thanks,
Joe

"Joe" wrote in message
news:BF4E7F48-EC9F-4DC1-AB17-1285339D5B65@microsoft.com...
> 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
>