Error while opening database

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Out of what seems to be nowhere, one of my client's stores just stopped working. We are getting the "Error while opening database" error.
I have checked the following items:
1. The Path is the same
2. The database is in the same location
3. Downlaoded the db, did a compact and repair, re-uploaded, no go
Any other suggestions?

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
rheide Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 13-December-2005 Status: Offline Points: 0	Post Options Post Reply Quote rheide Report Post Thanks(0) Quote Reply Topic: Error while opening database Posted: 13-December-2005 at 5:16pm
	Out of what seems to be nowhere, one of my client's stores just stopped working. We are getting the "Error while opening database" error. I have checked the following items: 1. The Path is the same 2. The database is in the same location 3. Downlaoded the db, did a compact and repair, re-uploaded, no go Any other suggestions?

ProductCart Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135	Post Options Post Reply Quote ProductCart Report Post Thanks(0) Quote Reply Posted: 13-December-2005 at 6:16pm
	Please do not use the Forum for technical support requests. Open a support ticket instead. As for your specific problem: are you sure the server is running properly? Edited by earlyimp - 13-December-2005 at 6:16pm
	The ProductCart Team Home of ProductCart shopping cart software

rheide Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 13-December-2005 Status: Offline Points: 0	Post Options Post Reply Quote rheide Report Post Thanks(0) Quote Reply Posted: 13-December-2005 at 6:25pm
	The rest of the client's site is running smootly. We are trying to find out if they made any changes to the server that we don't know about. Sorry for posting here, I'm used to posting things like this in a forum so other people can read/learn and help themselves. Regardless, I love the new forums. I never liked the old way! :-)

amgqmp1 Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 01-November-2005 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote amgqmp1 Report Post Thanks(0) Quote Reply Posted: 14-December-2005 at 11:54am
	From my experience...(I had this problem occur for over a year)...it can be a file-locking issue (if you are using an Access DB). One thing that every ProductCart Admin using an Access DB should know...is that you really shouldn't perform a normal file copy backup of the Access DB (from my experience). Standard file copies perform some extra tasks that can interfere with IIS and make the store go kaboom (until IIS or the system are restarted). For over a year my shop would run a backup script in the middle of the night...and if someone tried to access the store while the file copy was happening...it blew up. The solution for us was to write a command-line file copy program that perform the most basic of file copies. Our store hasn't had a single hiccup since I impleneted that 5-6 months ago. Not sure if any of this is applicable in your case...but, from my experience it's an important caveat to know about when employing any backup schema that might involve the transfer of the Access DB while the store is running.

watercrazed Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 31-December-2005 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote watercrazed Report Post Thanks(0) Quote Reply Posted: 13-January-2006 at 2:16am
	Hi, When I have this problem, reclying the asp application pool on the server fixes it. Some code is leaving database connections open and eventually chokes it I think.
	John massagers, heat therapy, buckwheat pillows and more

ProductCart Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135	Post Options Post Reply Quote ProductCart Report Post Thanks(0) Quote Reply Posted: 13-January-2006 at 10:53am
	Make sure your header.asp and footer.asp are not the culprit. If you need us to further look into the issue, please open a support ticket.
	The ProductCart Team Home of ProductCart shopping cart software