HELP!!!
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=20872
Printed Date: 09 April 2026 at 2:54am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: HELP!!!
Posted By: slayer051
Subject: HELP!!!
Date Posted: 31 July 2006 at 8:21pm
|
I have this error on my forum please help!! Server Error in Forum Application An error has occured while connecting to the database. Please contact the forum administrator. Support Error Code:- err_Access_db_connection File Name:- common.asp Error details:- Microsoft JET Database Engine Could not use ''; file already in use. |
Replies:
Posted By: dpyers
Date Posted: 31 July 2006 at 9:54pm
|
Looks like your connection string may be set up with extra or missing quote characters
------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: dfrancis
Date Posted: 31 July 2006 at 11:03pm
now that's just freaky
|
dpyers wrote:Posted By: slayer051
Date Posted: 01 August 2006 at 3:27am
| Its work great but when many users some time I get this error |
Posted By: dpyers
Date Posted: 01 August 2006 at 4:49am
|
http://aspfaq.com/show.asp?id=2009 - http://aspfaq.com/show.asp?id=2009
-------------
Lead me not into temptation... I know the short cut, follow me. |
Posted By: slayer051
Date Posted: 01 August 2006 at 10:12pm
|
Any easy idea to fix
this problem???? I can't access the registry. |
Posted By: dpyers
Date Posted: 02 August 2006 at 1:36am
|
At this point then, I'd check to make sure that any add-on/mod code was properly closing db connections, and that I was using the right mdac/ado version for the forums. I think you need mdac 2.8 - check the install directions to find out exactly. If your mdac is ok, and your connections are not being left open, then you've probably exceeded the number of users you can habdle with an access db on that host. The mdac thing is probably a long shot though - I think you'd see failures with less users if it was an invalid mdac. the following asp code can check your mdac/ado versionL dim objAdoVer Set objAdoVer = Server.CreateObject("adodb.connection") response.write "ADOVersion = " & objAdoVer.Version Set objAdoVer = Nothing -------------
Lead me not into temptation... I know the short cut, follow me. |
Posted By: slayer051
Date Posted: 02 August 2006 at 4:43am
|
Common.asp setup just let me know if this is ok 'Set the timeout of the forum Server.ScriptTimeout = 90 Session.Timeout = 20 'Set the date time format to your own locale if you are getting a CDATE error '(this shouldn't ever be required in version 8 or above, but left in for backward compatibility) 'Session.LCID = 1033 |
Posted By: Mikey
Date Posted: 02 September 2006 at 5:29pm
|
Moved to Support forum! Just a side note member_profile.asp?PF=24353&FID=20 - slayer051 , when you post a support question it's a better idea to use a descriptive title instead of just 'HELP!!!' this will help your question get answered and hopefully resolved much quicker! Just something to bear in mind for the future  ------------- Handyman man? |
Posted By: WebWiz-Bruce
Date Posted: 03 September 2006 at 11:26am
If this only happens when you get allot of users on your forum it means that Access is at it's connection limits. MS Access is only a flat office desktop file and can NOT cope with many connections (usually 20 shared with all Access databases on the entire web server). If you expect more than a handful of users per day you need to be running the mySQL or SQL Server versions as these are Database Management Systems (DBMS) rather than a desktop file so can handle many 1000's of simultaneous users. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |