ODBC Connection 80004005

<i><b>Originally posted by : cassandra (limbeehar77@yahoo.com)</b></i><br />Hello,<br /><br />I encounter:- <br /><br />"Provider error '80004005' <br /><br />Unspecified error <br /><br />/fyp.asp, line 26 "<br /><br />Line 26: cnnExcel.Open "DRIVER={Microsoft Excel Driver (*.xls)};"_<br /> & "DBQ=" & Server.MapPath(" emp.xls") & ";"<br /><br />when refreshing the page continuous. But this happens irregularly. My data source is an excel file which constantly updates the data. Pls help.....<br /><br /><br />

<i><b>Originally posted by : Geoff (lansberry@satc.com)</b></i><br />I'm having a similar problem - I have seen that message too. If I wait a few minutes and then refresh the page the message changes to:<br /><br />Microsoft OLE DB Provider for ODBC Drivers error '80004005' <br /><br />[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. <br /><br /><br />I don't understand what is going on either- the exact same code used to work just fine. <br /><br /><br />------------<br />cassandra at 12/7/2000 1:46:08 AM<br /><br />Hello,<br /><br />I encounter:- <br /><br />"Provider error '80004005' <br /><br />Unspecified error <br /><br />/fyp.asp, line 26 "<br /><br />Line 26: cnnExcel.Open "DRIVER={Microsoft Excel Driver (*.xls)};"_<br /> & "DBQ=" & Server.MapPath(" emp.xls") & ";"<br /><br />when refreshing the page continuous. But this happens irregularly. My data source is an excel file which constantly updates the data. Pls help.....<br /><br /><br />