Provider Unspecified error

[new2unix]

Hi,

I am using a PWS on a NT Workstation with Access2K db. The following asp codes essentially worked but if I reloaded the same page immediately after it's already been display, the following error appeared:

Provider error '80004005'

Unspecified error

/chp2/chp6/Display_Products.asp, line 4

If I waited for a few minutes then reload the page, the records would be properly displayed. Is there somthing that I overlooked?

Thanks

Mike


================================
<%
' Open Database Connection
Set Con = Server.CreateObject( &quot;ADODB.Connection&quot; )
Con.Open &quot;accessDSN&quot;
' Open Recordset
Set RS = Server.CreateObject( &quot;ADODB.Recordset&quot; )
RS.ActiveConnection = Con
RS.Open &quot;SELECT * FROM Products&quot;
' Loop through Recordset
WHILE NOT RS.EOF
Response.Write RS( &quot;product_name&quot; ) & &quot;<br>&quot;
RS.MoveNext
WEND

RS.close
Set RS = Nothing

Con.Close
Set Con = Nothing
%>

 

[rac2]

Hello Mike,

You might try msdn.microsoft.com -> Support -> knowledge base where you will find articles like this one Article ID: Q183060
Troubleshooting guide for 80004005 and other errors.

FYI,
Richard

 

[new2unix]

Thanks Richard. I also located the article yesterday. This morning I rebooted the NT Workstation and has been reloading/refreshing the page like crazy and so far I have not been getting the same provider unspecify error. I wondered if the error was due to the db connection not properly closed from my ASP initially because I did not include the syntax Con.Close and Set Con=Nothing in the initial version of this ASP page. And once the error occurred, all subsequent effort to close the connection would not work well till the PC is actually rebooted. Of course, I have not exclude the possibility that there could be other inherent evil force at work from M$.

Mike