| Author |
 Topic  |
|
mortioli
Average Member
United Kingdom
898 Posts |
 Posted - 20 April 2003 : 12:17:23
|
Hiya,
I've posted this before, and read what could cause it etc, but my host said that nothing at their end could be causing it to happen.
The error is...
quote:
Microsoft JET Database Engine error '80004005'
Could not use ''; file already in use.
/forum/inc_header.asp, line 114
...and was wondering if it could have anything to do with any of these...
1. I run two forums, both on the same host, so because they are each opening connections to different databases, could it be screwing things up with drivers etc?
2. My website has an 'include' for an inc_header_site.asp, and config.asp etc, and so does the forum, so because they are both accessing the database, could this be the reason?
The site which has the problem is www.ckyalliance.co.uk and my other site is www.mortioli.co.uk (but I don't use it much, so unsure if the mortioli site gets the same errors)
It's been happening for a while now, and is annoying both me and my members/users 
Is there anyone which would be able to help me get rid of the problem? Please please please!
Thanks for your time!
Oli |
Edited by - mortioli on 20 April 2003 12:18:13 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 20 April 2003 : 13:16:03
|
| Make sure your database files are in Access 2000/2002 format and that you are using Jet OLEDB connection strings. That's as far as you can go by yourself. If it doesn't fix it, it means probably the servers cannot handle that many DB access requests. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
mortioli
Average Member
United Kingdom
898 Posts |
Posted - 20 April 2003 : 16:23:17
|
I use this connection string...
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=****" '## MS Access 2000
I take it that's the best one to use?
Thanks for the help mate! |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Doug G
Support Moderator
USA
6493 Posts |
|
|
mortioli
Average Member
United Kingdom
898 Posts |
Posted - 21 April 2003 : 08:17:28
|
quote:
Originally posted by ruirib
It is, but are your DBs in Access 2000 format?
Yeah, I'm sure of it.
I've contacted my host (oneandone), but they told me that it shouldn't be happening, because everything is fine at their end and I don't have enough users for them to cause this problem   |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 21 April 2003 : 08:56:54
|
| Although the file in use error is quite frequently associated with a permissions problem, the random nature of its occurrence always made me think differently. Since you are already using an Access 2000 DB and an OLEDB connection string, I don't think there is much else you can do. Still think it is a server problem, probably not related to the number of users in your own site, but on the overall users of the web server and possibly the resources available. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 21 April 2003 : 09:02:59
|
Here is a MS link that goes with the permissions explanation: http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q174/9/43.ASP&NoWebContent=1
I surely don't understand that as a reason, since the behavior is random, many times you don't get the error, sometimes you do. If it were a permissions issue, you'd expect it to manifest itself consistently... |
Snitz 3.4 Readme | Like the support? Support Snitz too |
Edited by - ruirib on 21 April 2003 09:04:32 |
|
|
|
mortioli
Average Member
United Kingdom
898 Posts |
Posted - 21 April 2003 : 13:59:42
|
It does appear quite a lot though. If you were to go on the forum, you'll probably come across it in a couple of minutes.
I just don't understand what could be doing it  |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 21 April 2003 : 14:37:38
|
Provide that link to your host and have them answer you. It's their responsability to fix that, this is not a Snitz issue.
Maybe check with them what MDAC they have installed and have them update it, if needed. Also make sure they have the latest Jet Service Pack installed. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 21 April 2003 : 16:00:46
|
If this error comes & goes, often that's because the server is overloaded and runs out of buffer space for the jet connections. At least that's what I've seen in the past on a underpowered server.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
mortioli
Average Member
United Kingdom
898 Posts |
Posted - 25 May 2003 : 13:55:54
|
I haven't had any response from my host, but I've come across this error a couple more times...
I set up a guestbook from WebWizGuide.com, which worked fine offline, but when I uploaded it to my host, it gives me the file in use error all the time (even after refresh)... www.ckyalliance.co.uk and click on guestbook.
Also, I set up the IP Gate on my forum today, and as soon as I included the inc_ipgate.asp file in inc_header.asp, it gives me the file in use error (even after refresh)
Would this be the same problem as people have explained, or is it something more complex!?
Thanks again! |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
mortioli
Average Member
United Kingdom
898 Posts |
Posted - 26 May 2003 : 04:24:17
|
| Max number of users online at one time, is about 25 members |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 26 May 2003 : 06:02:38
|
| Well you may want to have a look to see what that file does that may cause this. My belief, however, is that this is mainly caused by your server which, is quite likely, overloaded. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Beaudoin
New Member
Canada
75 Posts |
Posted - 26 May 2003 : 09:34:06
|
I'm getting the same error Mortiolli, and it doesn't happen all the time, only very rarely, and I don't have very many users and I am using an Access 2000 database.
So... I'm a little confused myself. |
Jason Beaudoin
Army Web Designer
Canadian Army
|
|
|
|
Topic |
|
Topic Locked
