Print Page | Close Window

Error in Web Wiz Forums (common.asp)

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=142
Printed Date: 28 March 2026 at 10:23pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Error in Web Wiz Forums (common.asp)
Posted By: MizardX
Subject: Error in Web Wiz Forums (common.asp)
Date Posted: 13 February 2003 at 5:54pm

Got this error when trying to view the forum on my own server:
(roughly translated)

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][Driver for ODBC Microsoft Access] Can not use '(unknown)'. The file is already in use.
/forum
/common.asp, line 192

I think it has something to do with:

strSQL = "SELECT tblConfiguration.* From tblConfiguration;"
rsConfiguration.Open strSQL, strCon



-------------
/miz



Replies:
Posted By: MadDog
Date Posted: 13 February 2003 at 5:57pm
check your database path.

-------------
http://www.iportalx.net" rel="nofollow">


Posted By: MizardX
Date Posted: 13 February 2003 at 5:59pm

Originally posted by MadDog MadDog wrote:

check your database path.

I've changed to System-DSN...

strCon = "DSN=wwForum;UID=;PWD="



-------------
/miz


Posted By: MadDog
Date Posted: 13 February 2003 at 6:02pm
then you have to remove the Server.MapPath() from the strCon

-------------
http://www.iportalx.net" rel="nofollow">


Posted By: MizardX
Date Posted: 13 February 2003 at 6:06pm

Originally posted by MizardX MizardX wrote:

strCon = "DSN=wwForum;UID=;PWD="



-------------
/miz


Posted By: MadDog
Date Posted: 13 February 2003 at 6:08pm
opps, my bad, i was thinking the wrong thing. MizardX has it right =P

-------------
http://www.iportalx.net" rel="nofollow">


Posted By: MizardX
Date Posted: 13 February 2003 at 6:08pm

Originally posted by MadDog MadDog wrote:

opps, my bad, i was thinking the wrong thing. MizardX has it right =P

then what could be the prob?



-------------
/miz


Posted By: MadDog
Date Posted: 13 February 2003 at 6:10pm
i told him to remove Server.MapPath() but he is using a DNS connection .... i wasnt thinking straight.

-------------
http://www.iportalx.net" rel="nofollow">


Posted By: MizardX
Date Posted: 13 February 2003 at 6:12pm
i'll check for answers tomorrow... gotta sleep now...

-------------
/miz


Posted By: dolby71
Date Posted: 16 February 2003 at 3:47pm
Try not using DSN....


Posted By: turdfurgeson
Date Posted: 17 February 2003 at 12:43am
You may also want to check to see if there is a lock file on the site.  ie: wwwForum.ldb  <--  I think that is the correct extension type.  It would be located in the same directory as the database.  Typically, for a web application, this lock file has no effect on the use of the database but you never know.  Either that or it may be possible that the connection to the database is not being closed correctly and their are open active connections that have some how locked the database.  I don't know about this one though, just a thought.


Posted By: gr8indianbear
Date Posted: 17 February 2003 at 1:25am
my suggestion earlier was to compact and repair the database if it's in Access...guess it's nto working...


Posted By: gr8indianbear
Date Posted: 17 February 2003 at 1:27am

or how bout this, the database may not be locked properly...check this article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;306518 - http://support.microsoft.com/default.aspx?scid=kb;en-us;306518



Posted By: djscout
Date Posted: 17 February 2003 at 5:01am

thats a good page to bookmark and keep in handy for that nasty error we all love =)

 



-------------
++ jim..


Posted By: hockenpj
Date Posted: 17 February 2003 at 5:14am

Originally posted by turdfurgeson turdfurgeson wrote:

You may also want to check to see if there is a lock file on the site.  ie: wwwForum.ldb  <--  I think that is the correct extension type.  It would be located in the same directory as the database.  Typically, for a web application, this lock file has no effect on the use of the database but you never know.  Either that or it may be possible that the connection to the database is not being closed correctly and their are open active connections that have some how locked the database.  I don't know about this one though, just a thought.

a .ldb file is created by Access when it doesn't shut down properly, when you first install WWG Forum the fileill be a .mdb and then as the Forum is used a .ldb will be formed as well.



Posted By: MizardX
Date Posted: 17 February 2003 at 9:52am

It wasn't the permissions, nor did i find the error on the pages you gave me...

After a reboot everything worked... dunno what was wrong



-------------
/miz



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net