Access Database replacement requires web service restart

The error reads:

Error Source: Default.asp
Error Number: -2147467259
Error Description: Unspecified errorCould not open database connection.

This is running on Windows 2000 Server SP4. IIS and FPSE are installed
and configured. I've also been told that if it's left alone for 20 - 30
minutes it corrects itself which makes me wonder if there is some kind of
caching going on.

Mike



"Tom Kaminski [MVP]" <tomk (A@T) mvps (D.O.T) org> wrote in message
news:boo3m1$8v14@kcweb01.netnews.att.com...
 > "Michael Jones" <mike.DeleteThis@msdn.com> wrote in message
 > news:u10Hwc4pDHA.372@TK2MSFTNGP11.phx.gbl...
  > > I have a hosted customer who updates their website by replacing an
access
  > > database. The asp code hits the access database using a dns-less
  > > connection. Every time the database gets replaced, the web page starts
  > > displaying a database error message and failing until the web service is
  > > restarted. Once the service is restarted, all is fine again. Has
anyone
  > > seen this? Is the a prescribed fix so the database can be replaced
 > without
  > > the service having to be restarted?
 >
 > Hard to suggest a fix without knowing the error message it fixes ...
 >
 > --
 > Tom Kaminski IIS MVP
 > <a style='text-decoration: underline;' href="http://www.iistoolshed.com/" target="_blank">http://www.iistoolshed.com/</a> - tools, scripts, and utilities for running
IIS
<font color=purple> > <a style='text-decoration: underline;' href="http://mvp.support.microsoft.com/</font" target="_blank">http://mvp.support.microsoft.com/</font</a>>
<font color=purple> > <a style='text-decoration: underline;' href="http://www.microsoft.com/windowsserver2003/community/centers/iis/</font" target="_blank">http://www.microsoft.com/windowsserver2003/community/centers/iis/</font</a>>
 >
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Access Database replacement requires web service restart 

"Michael Jones" <mike RemoveThis @msdn.com> wrote in message
news:esgBVc7pDHA.2536@tk2msftngp13.phx.gbl...
 > The error reads:
 >
 > Error Source: Default.asp
 > Error Number: -2147467259
 > Error Description: Unspecified errorCould not open database connection.

For that error code, start here:
<a style='text-decoration: underline;' href="http://www.aspfaq.com/2009" target="_blank">http://www.aspfaq.com/2009</a>
<a style='text-decoration: underline;' href="http://www.aspfaq.com/2413" target="_blank">http://www.aspfaq.com/2413</a>

--
Tom Kaminski IIS MVP
<a style='text-decoration: underline;' href="http://www.iistoolshed.com/" target="_blank">http://www.iistoolshed.com/</a> - tools, scripts, and utilities for running IIS
<a style='text-decoration: underline;' href="http://mvp.support.microsoft.com/" target="_blank">http://mvp.support.microsoft.com/</a>
<a style='text-decoration: underline;' href="http://www.microsoft.com/windowsserver2003/community/centers/iis/" target="_blank">http://www.microsoft.com/windowsserver2003/community/centers/iis/</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Access Database replacement requires web service restart 

Hi Michael,

I agree with Tom. To download MDAC 2.8, visit the following Web site:
http://www.microsoft.com/downloads/details.aspx?familyid=6c050fe3-c795...7d-b037

Please feel free to let me know if you have any questions.

Does this answer your question? Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
 >> Stay informed about: Access Database replacement requires web service restart 

I installed MDAC 2.8 and Jet 4.0 SP8. I also had the user convert the
database to access 2000. The problem seems to be fixed. Thanks! Also,
thanks for the pointer to aspfaq.com. It has a lot of great information and
has now been added to my favorites list.

Mike


"Wei-Dong Xu [MSFT]" <v-wdxu.TakeThisOut@online.microsoft.com> wrote in message
news:pgERHwDqDHA.2088@cpmsftngxa06.phx.gbl...
 > Hi Michael,
 >
 > I agree with Tom. To download MDAC 2.8, visit the following Web site:
 >
<a style='text-decoration: underline;' href="http://www.microsoft.com/downloads/details.aspx?familyid=6c050fe3-c795-4b7d-b037-185d0506396c" target="_blank">http://www.microsoft.com/downloads/details.aspx?familyid=6c050fe3-c795...7d-b037</a>
 >
 > Please feel free to let me know if you have any questions.
 >
 > Does this answer your question? Thank you for using Microsoft NewsGroup!
 >
 > Wei-Dong Xu
 > Microsoft Product Support Services
<font color=purple> > Get Secure! - <a style='text-decoration: underline;' href="http://www.microsoft.com/security</font" target="_blank">www.microsoft.com/security</font</a>>
 > This posting is provided "AS IS" with no warranties, and confers no
rights.
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Access Database replacement requires web service restart