| Author |
 Topic  |
|
bwilcox
Starting Member
USA
14 Posts |
 Posted - 13 February 2001 : 00:25:57
|
After a couple weeks of the forum running smoothly, I have received this error message the past couple days. Last time, I simply republished the inc_top.asp file and everything was ok. This time, it did not correct. Here's the error:
Microsoft JET Database Engine error '80004005'
Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt.
/forum/inc_top.asp, line 42
Am not using SQL server, simply the Access dbase included in Snitz published directly to the win 2000 server. Any ideas on what is corrupting the file?
Thanks in advance.
|
|
|
Warchild
Starting Member
USA
46 Posts |
Posted - 18 February 2001 : 14:01:46
|
Can someone answer this question?
I am having the exact same problem!
Line 42 of inc_top.asp is (?)
my_Conn.Open strConnString
|
 |
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 18 February 2001 : 14:26:37
|
We're have the exact same problem here at the site (see: http://forum.snitz.com/archive/) with at script that isn't created by us.
I don't know what is causing this (yet), but it is a serious and annoying problem.
Pierre |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 18 February 2001 : 14:41:38
|
Gor, try the 4.0 access driver if you moved the site to W2K.
Otherwise 95% it's a permissions problem. I've seen the error when I used a domain account for the web server with some incorrect permission settings.
======
Doug G
====== |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 18 February 2001 : 14:51:52
|
Well, now I really don't know why it works/doesn't work.
I knew I changed it from Jet to ODBC yesterday because it didn't work then, and after that it worked. So I thought it was Jet that was causing it.
After your post, I changed it back to Jet and the page displayed again.
Then I thought, well lets check ODBC again, see if I can recreate the problem.
But the original connectionstring using ODBC (not changes made) worked also.
Changed back to Jet, then suddenly that didn't work anymore.
Back to ODBC, worked.
Back to Jet (again), worked again also.
Note: all I did each time was comment out the one line and uncomment the other.
Pierre |
|
|
|
Warchild
Starting Member
USA
46 Posts |
Posted - 18 February 2001 : 15:58:32
|
Burlee replied with this...
>>Thank you for writing. Please try your site now as the errors should be corrected. As the errors were only particular to your site, and others were able to run ASP on the server, we strongly recommend that you check your ASP code using the following guidelines:
http://msdn.microsoft.com/library/psdk/bdg/bdgapp03_3rhv.htm
http://msdn.microsoft.com/workshop/server/asp/ASPtips.asp
http://msdn.microsoft.com/voices/server03272000.asp
http://www.15seconds.com
These guidelines will help you in creating efficient code that will help work around memory leak issues so that your ASP scripts will terminate properly, return the virtual memory to the system and, as a result, execute more successfully without the errors that you experienced. Some common suggestions are to look for loops in your scripts and to make sure that only one scripting language is used per page.
The problem was a result of a memory leak caused by the ASP scripts on your site. Please refer to the following link as it addresses ASP's functionality integrated with IIS 4.0:
http://support.microsoft.com/support/kb/articles/Q188/3/52.ASP
While the fixes described in the article have been implemented, ASP memory leaks still exist, although not as much as before. Though we schedule and execute various processes to ensure that there is always enough virtual memory for ASP service, the problems associated with ASP are highly unpredictable, and we do our best to ensure that the service is continuous if ever excessive memory leaks occur. Again, such ASP memory leaks are an inevitable result of hosting on a shared NT server running IIS 4.0 - there are other clients on your Web server that also make use of virtual memory for their ASP scripts, and any one can destabilize the system.
Any comments or suggestions?
|
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 18 February 2001 : 16:24:47
|
Reading....
http://msdn.microsoft.com/library/psdk/bdg/bdgapp03_3rhv.htm
page not found
http://msdn.microsoft.com/workshop/server/asp/ASPtips.asp
This is a general, must read, page on how to code your ASP. I read this one before, nothing here that could really help us on this matter
http://msdn.microsoft.com/voices/server03272000.asp
Again a general, must read, page on how to code your ASP. I also read this one before, nothing here that could really help us on this matter
http://www.15seconds.com
great, a complete site to read
I'm kind of offended by this response (not by you but by Burlee).
Why ?
This is the "throw a lot of crap at a client asking questions we can't answer, if it is enough the client won't dare to come back with more questions" + "we're never wrong" + "hey, it works for others, so if it doesn't for you, you've got a problem"+ "we do all we can, the rest is up to you" + "we do a good job, now if it wasn't for all those customers we've got everything would be ok"
Warchild, the comments here are not aimed towards you, you just shared your info with us, was just venting, feel better now, but it didn't bring us closer to solving the problem.
Pierre |
|
|
|
CrEeP
Starting Member
6 Posts |
Posted - 18 February 2001 : 16:41:20
|
im getting the exact same error for jet except its here.
/snitz_forum/inc_functions.asp, line 644
if any one sloves the problem please mail it to me or post it on here.
thanks much!
|
|
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 18 February 2001 : 17:04:31
|
Quick question (maybe Doug can answer this one)
When does NT use the TEMP directory? Only when RAM is in use or is it whenever the connection is made? -If it is the former of the two, that could explain why these errors happen some times but not others. If memory is free it uses it, if not it tries to access the temp dir and finds permissions inadequate.
(...just guessing here, guys)
-Kerry
Edited by - kerry on 18 February 2001 17:05:18 |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 18 February 2001 : 17:26:57
|
Thanks, Doug - as always, your help is greatly appreciated. But I have to ask, do you have the entire Microsoft site memorized? Your ability to find / remember articles there is uncanny. Whenever I try to find anything via a search I usually end up with something about as relevant as "MS Bob" 
-Kerry
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 18 February 2001 : 17:28:31
|
quote:
The problem was a result of a memory leak caused by the ASP scripts on your site. Please refer to the following link as it addresses ASP's functionality integrated with IIS 4.0:
http://support.microsoft.com/support/kb/articles/Q188/3/52.ASP
Hmm, I guess these guys don't keep their web servers updated, since the article plainly states the memory problem is fixed in the latest NT4 service pack :) They probably liked the magic words 'redesign the web application' at the bottom of the article. Having spent most of my working life in tech support, a statement like 'redesign the web application' to a support tech is like a life preserver to a person in the ocean.
======
Doug G
====== |
|
|
|
Warchild
Starting Member
USA
46 Posts |
Posted - 18 February 2001 : 17:44:17
|
Well, how inSTRESSting, I'll write them and tell them that.. if it isn't fixed soonish I will probably be looking for a new Host...
Hmm Snitz seems nice.. Just noticed that snitz is also used for online gaming, how cool... My domain is used for RPGs (The pen and paper kind).. anyway I digress..
It does seem odd that I Keep having these problems.. should have gone with Unix hosting Grrrrrrrr
quote:
Hmm, I guess these guys don't keep their web servers updated, since the article plainly states the memory problem is fixed in the latest NT4 service pack :) They probably liked the magic words 'redesign the web application' at the bottom of the article. Having spent most of my working life in tech support, a statement like 'redesign the web application' to a support tech is like a life preserver to a person in the ocean.
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 18 February 2001 : 17:50:50
|
quote:
Thanks, Doug - as always, your help is greatly appreciated. But I have to ask, do you have the entire Microsoft site memorized? Your ability to find / remember articles there is uncanny. Whenever I try to find anything via a search I usually end up with something about as relevant as "MS Bob"
"find" is the operative word. My memory is quite good, but short.
Computers are way to complex to try to remember things. I try to concentrate on what travels between the 'big chunks' rather than the details. However, knowing where to find more information is the key. The web provides incredible resources, but it's difficult to wade through.
A few tips. Use quotes a lot when you are doing searches. Instead of searching for
It may not be a database that your application recognizes
use
"It may not be a database that your application recognizes"
If you want to see the difference, go to www.google.com and first search for the line above without quotes, then with quotes, and compare the result sets you get.
I keep a folder for web page saves (IE5 save as) as I run across articles and info that's in my line I throw the pages in this folder. Later W2K search can quickly find key phrases without going back out on the web.
MSDN library is a great tool, but at over 1gb of documentation, it's kinda overwhelming. I used the same technique I used back in school, don't worry about the content, concentrate on the table of contents instead. We used to get these 20lb piles of manuals, schematics, etc., back in the DEC days. Day one, I'd just read the table of contents for the manuals. By the end of the class it was much more valuable to know how to find information in a reasonable time rather than actually knowing anything.
======
Doug G
====== |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 19 February 2001 : 05:22:18
|
yeah, finding is great, but I sofar haven't found one document that was specific for this error. If I do a search for both the error number and the complete description it doesn't show results.
Pierre |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 19 February 2001 : 10:59:32
|
Try Deja (or what used to be Deja). There are quite a few threads there, and most answers are '..permissions'.
======
Doug G
====== |
|
|
|
Topic |
|
Topic Locked
