FN-FORUM: ASP Access db problem

date posted 17th August 2005 15:58

I have a colleague working on an ASP / Access project and he has inherited
code from a previous employee and there are problems occurring. The code
creates an ADODB Recordset object at the top of the page - this is then used
for all queries in the page i.e. the connection is opened - query undertaken
and then closed.
However, we are getting an error - Provider Error 80004005; however, if you
restart IIS then the web project works again. I am thinking it has to be
something to do with connections to the Access db here. I have had the
connection changed to a DSN connection (as it was DSN-less before as this
can cause this problem). Has anybody got any ideas about this? I was
thinking about having them create an ADODB Recordset object and
opening/closing a connection for every query but I am not sure what is the
best way of doing this?

Best Regards

John Kyle